Thanks,
How would I join 2 tables where I don't have a common column? I'm trying
to add the structure of one table to another.
Thanks
>In addition, you can combine the first select with DELETE/UPDATE
DELETE MyTable ;
> FROM MyTable ;
> JOIN (SELECT Id FROM MyTable WHERE SomeValue = 1) MyCursor
> ON MyCursor.Id = MyTable.Id
>
>
>>Thank you!
>>
>>>In VFP9 only
>>>DELETE MyTable;
>>> FROM MyTable;
>>> JOIN MyCursor ON MyCursor.Id = MyTable.Id
>>>
>>>UPDATE MyTable;
>>> SET SomeField = SomeValue;
>>> FROM MyTable;
>>> JOIN MyCursor ON MyCursor.Id = MyTable.Id
>>>
>>>
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people