mysql Full outer join two table

Question

I have two tables:
socials and social_links

I want all rows from first table and related rows from second table.

My code:

SELECT socials.*, social_links.*
FROM socials
LEFT JOIN social_links ON socials.id=social_links.social_id  
WHERE social_links.site_id=1

This code return 2 rows, but I want 4 rows where site_id=1.

First table socials:

Second table social_links:

id	social_id	site_id	link
1	1	1	https://www.facebook.com/lolo
2	2	1	https://instagram.com/test
3	1	2	https://www.facebook.com/koko

I want all rows from socials join with social_links where site_id=1.

jitender · Accepted Answer · 2022-10-28 08:42:52Z

1

instead of where add your condition in the join

SELECT socials.*,social_links.*
from socials     left join  social_links  on socials.id=social_links.social_id and social_links.site_id=1

answered Oct 28, 2022 at 8:42

jitender

10.4k1 gold badge22 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

very thanks , i do not know condition can be put in on