t1
, the outer table, has columns a
, b
and c
. It contains the following data:
1 20 23.09
t2
, the inner table, has columns a
, b
and c
. It contains the following data:
The join condition is WHERE t1.a=t2.a
.
The results table contains the following data: