SQL Select line with most recent date

Vote count:

0

I have two tables. One table for purchase orders and another table for purchase order lines.

I need price and currency for a specific part and I need the row returned to be the latest record in the database.

I figure since I want the latest record I need to select the max(date) the only issue is that since I need the 'group by', my results get grouped and it doesn't just return the single row with the latest date and it's price and currency.

asked 40 secs ago

Alexf11

3

SQL Select line with most recent date