Yak Posting Veteran
Posted - 07/30/2012 : 20:35:03
| Hey Guys,
I have a results table that returns warehouse codes and item codes.
all items exist in all warehouses but I only want to return the rows where an item exists in the warehouse from the above query.
I was thinking
something like this:
where itemcode and warehouse IN (select query)
but that doesn't work.
If i go where item code in (select query)
warehouse in (select query)
it will return way too many rows.
hope this makes sense.