Select query...

[polo]

Hello,

I am trying to run a select query which I can't get to work.

What I want to do is select a purchase order number from table1 then (possibly using a subquery?) do another select where it will return the most recent version number (from table2) for the purchase order number returned in the first select statement...

Does anyone know how I could do this?

Thanks

 

[wazz]

- how will you select the purchase order number from table 1?
- version number?

 

[KeithG]

I was wondering the same thing.