joining multiple tables

[Jaynesh]

Hello I have query I would like to know how I would go about doing this. (highlighted in red) Joining share.user_id with something other then dbPosts.

 

SELECT *

FROM dbPosts

 

LEFT JOIN dbUsers

ON dbPosts.username_id = dbUsers.id

LEFT JOIN dbPosts_share

ON share.user_id = dbFriends.friend_id

[Kustom_Vegas]

should be able to simply add another table into your join statement..

 

"SELECT * FROM dbPosts, dbUsers, tbl_2 WHERE dbPosts.username_id = dbUsers.id AND share.user_id = tbl_2.field"

[Jaynesh]

hi is there no way of doing by still using LEFT JOIN?

[Kustom_Vegas]

what i gave you is a form of a join, why do you need the word JOIN in the statement if my method works?

 

But if you insist...here

[Jaynesh]

Hi

 

Isnt left joins and inner joins a more healthier alternative?

[fenway]

You seem to be posting a lot of topics on the same single item.