How to make LEFT OUTER JOIN except some colums?

Question

I have 3 tables:

First "placement"

Second "user_info"

Third "user_placements"

I want to get all placement data with user infos,

How to do it?

I tried this, but result it not what I expected:

SELECT *, user_placements.id AS user_placements_id, placement.id AS placement_id
FROM placement
LEFT OUTER JOIN user_placements ON placement.id = user_placements.id_placement

Answer 1

you need to one more join with user info

SELECT placement.*,user_info.id as user_info_id,user_info.name as user_name,user_info.mobile as user_mobile
 FROM placement LEFT OUTER JOIN user_placements ON placement.id = user_placements.id_placement
    LEFT OUTER JOIN user_info ON user_info.id = user_placements.id_user