Sobes.tech
Intern — Middle

What does LEFT JOIN return when there are duplicate rows in the tables

livecode

Task condition

The example contains two tables — t1 and t2, with repeating values. It is necessary to determine which set of rows will be obtained after executing the following query.

t1  t2
1  1
1  1
1  1
2  3
2  3
  2
  2

select * from t1 left join t2 on t1.x = t2.x