| Subject: | Re: Local SQL Delete queries select statement
| | Date: | Wed, 12 Feb 2020 08:31:29 -0600
| | From: | Mark Bannister <markRemove@THISinjection-moldings.com>
| | Newsgroups: | pnews.paradox-development
|
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
>> sub-query?
>> DELETE FROM ':PRIV:I0IPDIMXREF2.DB'
>>
>> WHERE (id =
>> (SELECT id5
>> FROM ':PRIV:__Sql_run68.db' )
>> )
>>
>> Reports it works. Doesn't delete anything.
>> --
>> Mark B
>
|
