Hi, Derek-
> 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...
Trying a suggestion out in code first is sometimes helpful. <s> See my reply
to Michael with code snippet. The only time you'd need to alias the field is
if you're joining tables, AFAICT.
Regards-
Nancy Folsom
Pixel Dust Industries
Author _Debugging_Visual_FoxPro_Applications_
http://www.hentzenwerke.com/catalogpricelists/debugvfp.htm
©2004 Nancy Folsom |
