[SOLVED] Join

[The Little Guy]

SELECT * FROM users, profileInfo WHERE 
profileInfo.owner = users.id 
AND
users.id = '2'

 

There is my SQL, It doesn't work if their is nothing in profileInfo for that specific user. but if there is, it works fine.

 

I don't remember how to do this, but how to I get it to return a row even if the user has nothing in profileInfo, but does have user info in the table user?

[jvrothjr]

select * from users left join profileinfo on profileinfo.owner = user.id where users.id = '2'

 

something like that