I have an xls file with a bunch of rows. The rows include columns order number and dollar amount. I need to add 1 more column (address ID) to the XLS. The problem I'm having is that in the XLS, a given order number can be in there 2 or more times because the order may have been split-shipped. So, in my select's where clause, I will be passing a given order number 2 or more times and I need my result set to return the same number of times that I'm passing it.
ORDER . AMOUNT
12345 . 100.00
12345 . 95.98
12346 . 10.22
select order,address from order where order in (12345,12345,12346,...) order by order;
when I run this, I only get back 12345 1 time. Is there anyway I can get back a result with 12345 in there twice