Select t1.name, t2.diplomatype from studentmaster t1, resultmaster t2 where t1.result = t2.result or t1.result is null
Select t1.name, t2.diplomatype from studentmaster t1 LEFT OUTER JOIN resultmaster t2 on t1.code = t2.code where 1=1
SELECT * FROM StudentMaster T1 LEFT JOIN RESULTMASTER T2 ON T1.Result = T2.Result
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)