I'm being asked to do this query in one step, and I'm not sure it's possible.
I have a table of data entry and an audit table that records changes to the data. They want all data of a certain type (status "open") and the date and username from the *latest* audit entry for each row. The only way I can think to do it is with a subselect in the join condition, but this doesn't look possible from the help and my experimenting. Anyone? Yes, it's all in native VFP (8.0). Mark _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
