Three tables query

Epifanio Pineda Guadarrama posted at 03-Jul-08 12:25

Hi, since I'm new to queries I have a "big" problem unless for myself when trying to join three tables. What I want to do is as follows:

I have three tables  named: sales, detailsales and items

sales relates to detailsales throuhg the key "sale" and 

detailsales relates to items throught the key "item"

What I want is a report that display the total of sales grouped by "item" included at detailsales for an specific date included at sales and filter for an specific "line" included at items table.

Hope some one can help!!

Thanks in advance


Click here to sign in and reply. You could earn money via our $500 contest just for being helpful.
  Three tables query - Epifanio Pineda Guadarrama  03-Jul-08 12:25 12:25:18 PM
      hi see this - bretto kumar A  03-Jul-08 01:07 1:07:56 PM
      hope you want query like this! - sundar k  03-Jul-08 01:16 1:16:20 PM
      USE IT - Arvind Kumar  03-Jul-08 11:40 11:40:32 PM
View Posts