insertion - kathryn kasprow - com.mysql.lists.mysql

2 messages in com.mysql.lists.mysqlinsertion

From	Sent On	Attachments
kathryn kasprow	01 Dec 1999 11:28
sin...@cytanet.com.cy	02 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!