I just forgot to make the statement match my quickly done tables. I was trying to make it more clear. Amazing how many errors I spotted after a good nights sleep. lol
The statement does work! Turns out I picked a bulk location that was missing from the data. Arrrrrgggghhhhh...
So half a...
I have spent the day on this and still can't get it to give me the results I want.
Here is my data:
InvLocation (30,000 recs):
ID Location InvAvail
9005 22BULK 1
9004 22BULK 1
9004 22BULK 2
9004 22BULK 1
9006 22BULK 1
Items (80,000 recs):
ID Sku...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.