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

>>>