KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
Using the following query select * from table1 left join table2 on table1.name = table2.name table1 returns 16 rows and table2 returns 35 rows. I was expecting the above query to return 16 rows because of the left join , but it is returning 35 rows. right join also returns 35 rows Why is this happening and how do I get it to return 16 rows?
Tags (comma-separated)
Save Edits
Cancel