2 messages in com.mysql.lists.mysqlinsertion
FromSent OnAttachments
kathryn kasprow01 Dec 1999 11:28 
sin...@cytanet.com.cy02 Dec 1999 06:35 
Subject:insertion
From:kathryn kasprow (ngov@hotmail.com)
Date:12/01/1999 11:28:18 AM
List:com.mysql.lists.mysql

Hi,

I tried to insert the rows into the table using the tuples from another two tables. I typed the syntax as followed:

insert into assigned (prodno, Mlogin) select prodno from course where course='a123' and select Mlogin from manager where Mlogin ='kristine\@yahoo\.com';

I got an error message. It did not allow me to insert two rows from different tables? What is the syntax??

Thanks for advance!

MH