Re: [SQL] sum query

2004-12-04 Thread Kretschmer Andreas
am Sat, dem 04.12.2004, um 12:38:11 - mailte Andrew - Supernews folgendes: Thank you for the very good explanation. > Notice I haven't used either IN or UNION. Using IN in place of a join is > unwise (even though recent versions can sometimes plan it as though it were > a join); using UNION

Re: [SQL] sum query

2004-12-04 Thread Andrew - Supernews
[if replying, please do so to the list / newsgroup only, not to me] On 2004-12-03, "Keith Worthington" <[EMAIL PROTECTED]> wrote: > Hi All, > > I am trying to join three tables and sum the quantities. > > The first table contains all of the possible items. The second table > contains orders and t