Can you write a command or stored proc to do this?
You likley outer joined checks to checks_1 but your select statement is making your outer join into an inner join. Just using an "or condition" with isnull might partially correct the issue but I suspect it will still not get all of your rows, other wise you would not need the condition on the checks_1 payee field at all.
if you can alter your source to a command or stored proc you can add a condition on the join from checks to checks_1 to resolve your issue.
Edited by DBlank - 03 Oct 2013 at 5:59am
IP Logged
