Thanks for that Ted, Sorry for the lack of sample. You're quite right, in general, about how it should be though.
I also agree with you that I want a correlated subquery, but VFP (8) says it won't do it. I get a dialog box that says SQL: Queries of this type not supported Much to my surprise the following seems to work SELECT DataEntry.*, DEAudit.* ; FROM DEAudit ; JOIN DataEntry ON DataEntry.thisKey = DEAudit.thatKey ; GROUP BY DataEntry.thisKey ; ORDER BY DEAudit.tChanged DESC with a bit more ordering and filtering. Hmmm, doesn't look good at all, but, supplied by the lead developer from the client, I'll go with it for the moment. Hmmmmmm. Mark Stanton One small step for mankind... _______________________________________________ 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.
