Subject: | Re: Local SQL Delete queries select statement
| Date: | Wed, 12 Feb 2020 12:09:42 +1100
| From: | Tom Krieg <REMOVEtomkCAPITALS@sdassociates.com.au>
| Newsgroups: | pnews.paradox-development
|
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
|