The Foxil said: Paul, it seems very clever and a lot more simple than my solution. Best regards ############
and than mine AndyD 8-)₹ On 19:59, Paul Newton wrote: > Jean > > Thank you. However my approach will only return one row for each invalid > transaction. Each row will contain the unique references of an invalid > transaction. Your approach is better if Alan wants to see all the rows for > each invalid transaction. Perhaps he will let us know which approach he > prefers:) > > Paul > > -----Original Message----- > From:profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On > Behalf Of Jean MAURICE > Sent: 30 January 2012 15:22 > To:profoxt...@leafe.com > Subject: Re: An SQL Select poser. _______________________________________________ Post Messages to: ProFox@leafe.com 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/4f26d21f.1040...@gmail.com ** 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.