Re: help update tables from join

From: Michael Leung <wmleung_at_hk.super.net>
Date: Thu, 10 Dec 1998 22:30:59 +0800
Message-ID: <366FDB23.E941E7F0@hk.super.net>

Kevin,
If your tables are one to many, you may update the many side of the table in the join.

regards,
Michael

Kevin wrote:

> I am creating a join like this:
>
> Select *
> From table_x t1, table_y t2
> Where t1.name=t2.name AND t1.id=t2.id AND t1.id=xxx
>
> The data is retrieved from the tables but I can not update
> the tables. The vbscript logic works as long as I
> do not join tables.
>
> Is it possible to update two tables at once?
>
> This application is using ASP/VBScript and ODBC.
>
> Thanks
>
> Kevin
Received on Thu Dec 10 1998 - 08:30:59 CST