subqueries in inserts

Kim Schulz <[email protected]> Mon, 07 Mar 2005 10:34:07 +0100

Newsgroups	gmane.comp.db.mckoi
Organization	Aalborg University
Message-ID	<[email protected]>

hi,
Isn't mckoi supposed to support subqueries in inserts

like 

INSERT INTO table (col1,col2,col3)(SELECT col1,col2,col3 FROM table
WHERE col1='foo');

mckoi trows an error at the "(" in front of the sub SELECT, and if you
remove the "( )" around the subquery then it trows a NULL exception. 

what am I doing wrong here? 




-- 
   Kim Schulz   | Linux - Your Choice! Your Opinion! Your life!  
 Geek by nature | 
   schulz.dk    |   


---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to [email protected]