I have a stored procedure that returns invoice order numbers that did not seem to get processed.

from those numbers listed in my result set I then want to query out all those invoice order numbers that were cancelled from another table.

could someone give some sample code on how to do this?

so I get a bunch of numbers back from a query and now i want to query on those numbers and make sure none were cancelled???