main logo
Subject: RE: DELETE FROM with subselect
Author: "Brian Abbott"
Posted: 2004/02/28 12:08:00
 
View Entire Thread
New Search


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
============



 
©2004 Brian Abbott
<-- Prior Message New Search Next Message -->