>>Can i somehow create a temporary table and add all the rows i need and do a select query from that temp table. Yeah, that's the easiest way to do it. Create temporary table A..... insert into A select .... insert into A select .... select * from A ....
If you want to mimic 'insersect' features and such, just add unique constrainst to your table so that you don't insert duplicate data twice from your multiple inserts. Chris --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
