- My left table V1 will sometimes have a value of NULL for V1.prog_log_key
- I am trying to join this field, to the right table H1
FROM dbo.V_HEAD_DETA IL_Program AS V1
LEFT OUTER JOIN
dbo.T_ROAD_HEAD AS H1 ON V1.prg_lob_key = H1.RMAP_ID
- I want to keep the null values in the left table V1, if there is no match in H1
- the old join syntax, V1.prg_lob_key *= H1.rmap_id kept...