n" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 06, 2001 22:06
Subject: INSERT INTO 2 JOINED TABLES
> As an example to my problem, I have 2 tables, T1 and
> T2.
>
> T1's fields are Common,T1Field1,T1Field2 (Common is
> the primary key and
As an example to my problem, I have 2 tables, T1 and
T2.
T1's fields are Common,T1Field1,T1Field2 (Common is
the primary key and it is autoincrement)
T2's fields are T2Field1,Common,T2Field2 (T2Field1 is
the primary key)
I created a view using "SELECT
T1.T1Field1,T1.T1Field2,T2.T2Field1,T2.T2Fie
