• Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

Damn SQL Joins

found out the problem was not the join

it was the where clause which initially said

where print flag = 0 and audit type = 2

needed to add

or printflag = 0 and audit type = NULL

but cheers everyone rep on it is way!

Or just where print flag = 0 and COALESCE(audit type,2) =2
 

Advertisers

Back
Top