Hi,

I have a table called "Orders", that has a column called "OrderNum"

OrderNum TimeHrs Date
1234 5 1/3/2010
5678 7 1/10/2010
1423 8 1/12/2010
5867 2 1/11/2010
4425 8 1/12/2010
5567 2 1/11/2010
...

From that table I would like to SELECT all elements for a group of ODTs (e.g. 1234, 1423 and 4425) but using only one QUERY command.

Thanks,
Enrique.

Enrique,


Select OrderNum, TimeHrs, Date
From Orders
Where OrderNum In (1234, 1423, 4425)


Wayne