having a few synatx errors in my queries

[arobbo]

hi basically i'm trying to display the purchase order of the last order in a given time frame, i'm finding that using max(order_Date) isn't working , is there a way i can use max(order_Date) in my where clause or something like Where (order_Date) is the greatest

????

anyone got any ideas

 

[lupins46]

Something like:

Select * from mytable inner join (Select max(order_date) as MO from mytable where order_date >=#01/01/2004# and order_date<#01/01/2005#)) as q1
on mytable.order_date = q1.mo