[SOLVED] Quick Question

[Ell20]

Hi,

 

I am trying to join 3 tables together. I have only ever joined 2 tables together before and have used INNER JOIN.

 

Below is my attempt, but this is done using an INNER JOIN, not sure whether I have done it wrong, or its not possible to join 3 tables together using INNER JOIN?

 

$query = "SELECT player_id, type, price, username, crew, crewname FROM dom_london INNER JOIN user_info AND crews ON user_info.id = dom_london.player_id AND user_info.crew = crews.id WHERE dom_london.id = '$section'";
$result = mysql_query($query);
$row = mysql_fetch_assoc($result);

 

Any help is appreciated

 

Elliot

[craygo]

format is like this

 

$query = "SELECT player_id, type, price, username, crew, crewname
          FROM dom_london
          INNER JOIN user_info ON user_info.id = dom_london.player_id
          INNER JOIN crews ON user_info.crew = crews.id
          WHERE dom_london.id = '$section'";

 

Ray

[Ell20]

Thanks alot for your help!

[craygo]

Don't forget to mark topic as SOLVED

 

Ray