Like using "in (select ...... ) " which is equally poorly documented.
Dave -----Original Message----- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Alan Bourke Sent: 09 August 2017 15:33 To: profoxt...@leafe.com Subject: Re: SQL Error On Wed, 9 Aug 2017, at 03:21 PM, Laurie Alvey wrote: > I've only ever used EXISTS in T-SQL. Didn't know it could be used in VFP. > It doesn't seem to be documented anywhere - what about SOME or ANY? it's on the "Filter Conditions for Queries and Views" help file page. SOME and ANY also. -- Alan Bourke alanpbourke (at) fastmail (dot) fm [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/18725b8cd2d5d247873a2baf401d4ab2b478c...@ex2010-a-fpl.fpl.LOCAL ** 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.