MSSQL – JOIN ON null values


SELECT 

tbl_a.*, tbl_b.*

FROM 

tbl_a

INNER JOIN  tbl_b ON  tbl_a.name =  tbl_b.name OR ( tbl_a.name IS NULL AND  tbl_b.name IS NULL )
This entry was posted on Thursday, January 17th, 2019 at 4:07 pmand is filed under MSSQL Database Development. You can follow any responses to this entry through the RSS 2.0 feed. Responses are currently closed, but you can trackback from your own site.

Comments are closed.