Please tell me, i have a table in which i have defferent items wtih
different rates. i want to select all items having maximum rates. any one
tell me how can i do that
Thanks & Regards,

Can anyone please tell me if it is possible to use a subquery as an
aliased table as part of a JOIN:
SELECT jobs.job_number, ;
jobs.date as LoadDate, ;

I want to fetch some records through VFP9-ODBC-ORACLE connection, it works
well when I run the command below:
CREATE SQL VIEW test REMOTE CONNECTION Connect1 ;
as select * from patient where IDENTITY like '553%'