[PHP-DB] How do you make an IN span multiple tables?

2004-03-04 Thread Richard Davey
Hi, I'm a bit stuck with the following: I need to select data from 3 different tables and want to do it via a SELECT ... IN query. Each table has a primary key called thread_ref. I would like to do something like this: SELECT * FROM table1, table2, table3 WHERE

RE: [PHP-DB] How do you make an IN span multiple tables?

2004-03-04 Thread Gary Every
! -Original Message- From: Richard Davey [mailto:[EMAIL PROTECTED] Sent: Thursday, March 04, 2004 8:36 AM To: php-db Subject: [PHP-DB] How do you make an IN span multiple tables? Hi, I'm a bit stuck with the following: I need to select data from 3 different tables and want to do it via

RE: [PHP-DB] How do you make an IN span multiple tables?

2004-03-04 Thread Swan, Nicole
Programming Specialist Carroll College CCIT (406)447-4310 -Original Message- From: Richard Davey [mailto:[EMAIL PROTECTED] Sent: Thursday, March 04, 2004 7:36 AM To: php-db Subject: Spam:[PHP-DB] How do you make an IN span multiple tables? Hi, I'm a bit stuck with the following: I need