Select entries that are present in other table

[ennrike]

Hi,

I have two tables, TABLE1 that has a column "ORDER_NUMBER" (the primary key) and I have a second table TABLE2 that has also the column "ORDER_NUMBER" these two tables have relationship between using these two columns.

However, I have "ORDER_NUMBER" entries in TABLE2 that has a special column called "OVER_TIME" that is an integer for hours.

How can I select * the entries present in TABLE1 of time "ORDER_NUMBER" that are in TABLE2 and have the OVER_TIME > 5 hours.

Thanks,

 

[Guus2005]

You can try this:

select TABLE1.* from TABLE1 inner join TABLE2 
on TABLE1.ORDER_NUMBER = TABLE2.ORDER_NUMBER where TABLE2.OVER_TIME > 5

or

select TABLE1.* from TABLE1 where TABLE1.ORDER_NUMBER in 
(select TABLE2.ORDER_NUMBER from TABLE2 where TABLE2.OVER_TIME>5)

Both should work. The first one is faster.

Enjoy!