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: General SQL Question 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 way join. Is this possible? Thanks! Dan