- Joined
- Sep 3, 2014
- Messages
- 12,555
- Likes received
- 4,957
- Thanks received
- 1,118
- Location
- Work-life balance nirvana
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