How to implement this in SQL?

use a logic like below

SELECT t1.field1,
t2.field2,
t11.field3
FROM (SELECT DISTINCT Field1 FROM t1)t1
CROSS JOIN (SELECT DISTINCT Field2 FROM t2) t2
LEFT JOIN t1 t11
ON t11.field1 = t1.field1
AND t11.field2 = t2.field2

---

Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://ift.tt/19nLNVq http://ift.tt/1iEAj0c