> > Does this work?
> >
> > USE jobs
> > DELETE FROM jobs WHERE nJobID in (select njobid FROM crap)
>
> Nope! http://mbsoftwaresolutions.com/images/nope.JPG
How about:
DELETE FROM Jobs WHERE Jobs.nJobID IN (SELECT Crap.nJobID FROM Crap)
Maybe VFP is getting confused as to what table the first nJobID is in...
--
Derek
©2004 Derek J. Kalweit |
