SQL Join Interview question: Different types of SQL joins and describe the output each type produces?

What is the output of below query for all joins?     

 

SELECT T1.* FROM  T1 JOIN T2 ON T1.C1=T2.C1 AND T1.C2<T2.C2;

Use below data for your execution.

Execution Result are in below.

Inner Join

 No records display. why?

Left Join

 

Right Join

 why the right join results in null values?

Full Join

 

Youtube video: Join video