So I need a left outer join, because I am looking for where something isn’t. One thing that I have noticed is that if I put a criteria on the right table, it treats it like an inner join. Is this a SQL thing? Or an Epicor thing? Is this just the way it’s supposed to work? In this case I can get around it by putting the criteria in the sub query, but I won’t be able to always do that.
Interesting twist, I started messing with stuff, and now all of the sudden it’s working as expected. I don’t know what I did to make it work… I was just trying to get it back to the way it was to grab the code for you.
Haha, I can live with properly using it for some items. Problem is with writing over 100 reports with multiple temp tables and calculations etc…I would much rather just write SQL all day than the BAQs