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