Join Condition (Indirect)

frd relation

 select b.teur
 from tbl a left join TT b on (a.key=b.key)

Columns in the join condition also effect the number of row in the resultset of the select list just like column in the where clause do.

So, the following relation will be discoverd in the above SQL.

tbl.key -> fdr -> resultset.PseudoRows
TT.key -> fdr -> resultset.PseudoRows

diagram

join relation

A join relation will be created after analzye the above SQL. It indicates a join relation betwee tbl.key and TT.key.

diagram