RE: SQL Error

Like using "in (select ...... ) " which is equally poorly documented.

Dave

-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Alan Bourke Sent: 09 August 2017 15:33 To: profoxtech@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.