How to use subquery to select records? 1

[karibari]

I'm learning Crystal Reports. I want to filter the report to select records that meet 2 criteria. In SQL I would write:

SELECT project_num, user_name, trans_type, status_date, status_desc
FROM process_log p
WHERE status_desc != 'COMPLETED'
AND status_date = (SELECT MAX(status_date)
FROM process_log m
WHERE m.project_num = p.project_num)

I can't figure out how to convert this logic to Crystal. Any help is greatly appreciated. Thank you!!

 

[IanWaterman]

You can just use your query as a command object, and bring back exact data you require.

Ian