Andrew,
Tuesday, May 14, 2002, 10:56:43 PM, you wrote:
AL> On Tuesday 14 May 2002 06:10 am, Egor Egorov wrote:
>> If not, can I write the Query results of the SELECT statement out to a
>> new table and delete the original table?
>>
>> Yes, you can use CREATE ... SELECT statement.
AL> Thank
On Tuesday 14 May 2002 06:10 am, Egor Egorov wrote:
> If not, can I write the Query results of the SELECT statement out to a
> new table and delete the original table?
>
> Yes, you can use CREATE ... SELECT statement.
Thank you for the reply, Egor. Here is what I have tried since your rep
Andrew,
Tuesday, May 14, 2002, 12:43:31 AM, you wrote:
AL> I have a database with several tables. I want to update a field in that
AL> table with a field contained in another table. I have a unique key to use
AL> for a WHERE clause.
AL> This is easy to do with various procedural languages
