Re: [PHP-DB] SELECT FROM 2 or more tables

2003-08-20 Thread Brian Dailey
t to do. So you want to set a filter on the merged records, which can be anything, but is usually a match between a field in one table and a field in another table. That's a join in two sentences or less. On Wednesday, August 20, 2003, at 03:41 PM, John Ryan wrote: I cant grasp JOIN for t

Re: [PHP-DB] SELECT FROM 2 or more tables

2003-08-20 Thread Brian Dailey
John, It sounds like you need to read basic documentation on combining SQL queries. Basically, you need to have a column that is common across both tables. Eg., in TABLE1 have a column named TABLE1ID. Have the same ID cross referenced in TABLE2. The ID would be sequenced in some way (auto_incre