Re: [SQL] Multiple table join

2003-10-06 Thread Dan Langille
On 6 Oct 2003 at 10:26, Louise Cofield wrote: > I am attempting to select fields Location and Item_Num from table A > where A.Location = B.Location, > > AND > > select Item_Description from table C, where A.Item_Num = C.Item_Num. Try: select Location, Item_Num from table A, B, C where A.Loca

Re: [SQL] Multiple table join

2003-10-06 Thread Louise Cofield
That was way too simple -- thank you! -Original Message- From: Bruno Wolff III [mailto:[EMAIL PROTECTED] Sent: Monday, October 06, 2003 10:38 AM To: Louise Cofield Cc: [EMAIL PROTECTED] Subject: Re: [SQL] Multiple table join On Mon, Oct 06, 2003 at 10:26:59 -0600, Louise Cofield

Re: [SQL] Multiple table join

2003-10-06 Thread Bruno Wolff III
On Mon, Oct 06, 2003 at 10:26:59 -0600, Louise Cofield <[EMAIL PROTECTED]> wrote: > > I am attempting to select fields Location and Item_Num from table A > where A.Location = B.Location, > > AND > > select Item_Description from table C, where A.Item_Num = C.Item_Num. Just list all three tab

[SQL] Multiple table join

2003-10-06 Thread Louise Cofield
Greetings, SQL gurus!   I am attempting to select fields Location and Item_Num from table A where A.Location = B.Location, AND select Item_Description from table C, where A.Item_Num = C.Item_Num.     Any help would be appreciated.   Louise