That did not work either.

It is interesting to note that upcs are being returned that do not exist when running the subquery separately. It will work correctly if you...

That did not work. Also, if you remove the or ltrim(rtrim(warehouse_item)) = '' part of the main query it will work (of course not returning the warehouse_items that have a...