SQL subquery problem

#1

what is wrong with expression? using access 97

select [hjd-historical],vendname,[hjd-historical],lidesc,

from [hjd-historical]

group by [hjd-historical], vendname, [hjd-historical],lidesc

where (select max([hjd-historical],podate)

from hjd-historical];

i am trying to find the lst time a item was ordered

any help really appreciated

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SQL subquery problem

comp.database.ms-access comp.database.ms-access

SQL subquery problem - 10-26-2004 , 06:05 PM