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
[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
am 03.12.2004, um 16:33:40 -0500 mailte Keith Worthington folgendes:
> 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 the third table contains the items on each order.
>
> For a
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 the third table contains the items on each order.
For all items found in tbl_item I need the total quantity on open orders. If
an item is no
