Mark, Two steps are often faster than one even if you can do it in a single step. Is there a reason why it needs to be done in one step?
> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Mark Stanton > Sent: Monday, April 28, 2008 3:30 AM > To: [email protected] > Subject: Simple two step query possible in one? > > 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 > > > > [excessive quoting removed by server] _______________________________________________ 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.
