• I hope I dont confuse you here :

    Select T1.C1, T2.C2

    From T1 Left join T2

    on T1.C1 =. T2.C2

    is equivalent to

    Select T1.C1, T2.C2

    From T2 Right join T1

    on T1.C1 =. T2.C2

    The understanding, important to keep in mind, is that you want all data from table t1 regardless of if it has a join to t2. The same is not true of t2, you only return those that have a join to t1.

    ----------------------------------------------------