Query for more than one entrance

[kikeman]

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.

 

[WayneRyan]

Enrique,

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

Wayne