|Subject:||Re: Local SQL Delete queries select statement
|Date:||Wed, 12 Feb 2020 08:31:29 -0600
|From:||Mark Bannister <markRemove@THISinjection-moldings.com>
Doesn't work with DISTINCT either.
On 2/11/2020 7:09 PM, Tom Krieg wrote:
> I don't know much about local SQL but it won't work because the
> sub-query could return more than one result.
> try WHERE ID IN (SELECT id5 ... etc
> On 12/02/2020 5:21 am, Mark Bannister wrote:
>> Do local sql delete queries not work at all when using a select
>> DELETE FROM ':PRIV:I0IPDIMXREF2.DB'
>> WHERE (id =
>> (SELECT id5
>> FROM ':PRIV:__Sql_run68.db' )
>> Reports it works. Doesn't delete anything.
>> Mark B