Re: INSERT data into multiple tables

2003-09-24 Thread Antony Dovgal
On Wed, 24 Sep 2003 14:23:04 -0500 "Dan J. Rychlik" <[EMAIL PROTECTED]> wrote: > Hello, > > I have a question about INSERTing data into 2 different tables with one statement. > Can you do this? > > INSERT INTO table1 (name,address,phone) VALUES ( ' USER ', ' USERADDY ',' > USERPHONE') AND tab

INSERT data into multiple tables

2003-09-24 Thread Dan J. Rychlik
Hello, I have a question about INSERTing data into 2 different tables with one statement. Can you do this? INSERT INTO table1 (name,address,phone) VALUES ( ' USER ', ' USERADDY ',' USERPHONE') AND table2 (name) VALUES( ' USER '); -Dan