Are you sure that nJobID is the same type in both tables?
If there are character, are you sure they're the same length or, if they are,
EXACT is not on?
There's no reason this construct shouldn't work...
----- Original Message -----
From: "Brian Abbott" <brian (AT) abbott .D.O.T plus.com>
To: <profoxtech@leafe.com>
Sent: Saturday, February 28, 2004 9:12 AM
Subject: RE: DELETE FROM with subselect
> I just tried this and it worked fine:
>
> DELETE FROM sitedetl WHERE uid in (select id FROM notes)
>
> Definitely using vfp8, right?
>
> Michael J. Babcock wrote:
> > Brian Abbott wrote:
> >
> >> Does this work?
> >>
> >> USE jobs
> >> DELETE FROM jobs WHERE nJobID in (select njobid FROM crap)
> >
> > Nope! http://mbsoftwaresolutions.com/images/nope.JPG
>
> ============
> Brian Abbott
>
> ACA Systems
> ============
>
>
[excessive quoting removed by server]
©2004 Chet Gardiner |
