Excellent worked a treat.
I tried that - it didnt work, however i think i must have had a typo as it
works now!!!
Cheers,
Dan
From: "Patrick Dunnigan" <[EMAIL PROTECTED]>
Reply-To: sqlite-users@sqlite.org
To: <sqlite-users@sqlite.org>
Subject: Re: [sqlite] OT: General SQL
ey" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Saturday, April 30, 2005 7:36 AM
Subject: Re: [sqlite] OT: General SQL Question
well audititems has a field parentauditid which links into audits. Audits
has a supplierid field which is the key on suppliers..
From
well audititems has a field parentauditid which links into audits. Audits
has a supplierid field which is the key on suppliers..
From: "Patrick Dunnigan" <[EMAIL PROTECTED]>
Reply-To: sqlite-users@sqlite.org
To: <sqlite-users@sqlite.org>
Subject: Re: [sqlite] OT: General
It is possible depending on the make up of the tables.
post the table structures and index / keys and I'll help
- Original Message -
From: "Dan Keeley" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Saturday, April 30, 2005 6:38 AM
Subject: [sqlite] OT
Hi, I know this isnt related to SQLite, however i dont really know where
else to ask.
I have 3 tables - Supplier, Audits and Audititems.
At the moment, i select and join audits and Audititems and it works great.
However i need fields from the supplier chain, so i effectively need to do a
3
5 matches
Mail list logo