I know - to make difference and refer field from parent query in child query. Nice approach, and I think it should be in FAQ for VFP - SQL Server solutions.
>Yes. The important thing to note is that they alias the table in the main part of the select.
>
>PF
>
>>I guess category (i.e. grouping field) is jobid, right?
>>
>>
>>>The standard way in SQL to find the data that corresponds to MIN/MAX is to use a correlated sub-query.
>>>
>>>The example I have is:
>>>
>>>
>>>select
>>> jobid,
>>> status,
>>> supervisorid
>>> from jobprogress m
>>> where statusdate =
>>> (select max(statusdate)
>>> from jobprogress
>>> where jobid = m.jobid)
>>>
>>>
>>>
>>>The is the typical way to select 1 row for a given ID if there are multiple rows for each ID with a date for each row.
>>>
>>>PF
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.