[SOLVED] Quick Question

[Ell20]

Hi,

 

I have a query at the moment which works fine:

 

$query = "SELECT colour, type, type_2, player_id FROM dom_bogota";

 

However i would like to also get username from user_info table, I have tried using INNER JOIN:

 

SELECT colour, type , type_2, player_id, username FROM dom_bogota INNER JOIN user_info ON dom_bogota.player_id = user_info.id

 

However this only gives the results where username actually equals something.

 

Is there any way I can do the same thing but receive all results regardless of whether username equals something or not?

 

Thanks for any help!

[DeanWhitehouse]

u could have a seperate query

[Ell20]

Could but that isnt really an option for me in this case, thanks for the suggestion though.

[DarkWater]

Try a LEFT JOIN.

[DjMikeWatt]

I'm not an expert, and I'm sure someone will correct me if I'm wrong here... but why can't you just use:

 

$query = "
SELECT colour, type, type_2, player_id, username
FROM dom_bogota, user_info";

[Ell20]

Cheers DarkWater, left join worked a treat!

[DarkWater]

No problem.