Hello, I am trying to join 2 tables on ID. But one table may have 2 rows for same id, I want to take only one row. how can I do that?
For example:
table a
left join
table b
on a.id=b.id will return me 103 rows (because 2 ID got different rows)
table a will return me 101 rows
I want to have 101 rows after join