How do you do an update query in MS SQL when a left join is used?
I know this is close, but could anybody help me?
Set accountbase.[primarycontactid] = dbo.contactbase.[accountid]
Left Join dbo.contactbase
on dbo.accountbase.[accountid] = dbo.contactbase.[accountid]
where accountbase.[primarycontactid] is null
With just a little bit of SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form. If you have never written code or looked at an SQL statement before, no problem! ... give i…