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, 200

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 lo

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