Re: [PHP] multi-table select?

Try SELECT teams.*, divisions.id AS divisonid, divisions.name AS divisionname FROM teams LEFT JOIN divisions ON teams.divisonID = divisions.divisionID if the ids are the same you can actually also write ON teams.divisonID and omit = divisions.divisionID ... I think. hth toby I'm looking

RE: [PHP] multi-table select?

This is a basic table join: select * from teams, divisions where teams.divisionID = divisions.divisionID -Original Message- From: Kirk Babb [mailto:[EMAIL PROTECTED] Sent: Thursday, 15 January 2004 9:41 AM To: [EMAIL PROTECTED] Subject: [PHP] multi-table select? I'm looking

Re: [PHP] multi-table select?

i must overlooked that... no wonder my pages all take ages to load *g* ;) ;) - Original Message - From: Martin Towell [EMAIL PROTECTED] To: 'Kirk Babb' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 11:52 PM Subject: RE: [PHP] multi-table select