Hallo to all! I have troubles with one particular INSERT...SELECT. I have found no example in the manual and other -general- advices on the net do not work with MySQL. Could anyone help me with this: I have four tables. I would like to insert specific records from table1 to table 2 in column1, specific records from table3 to table2 into colum2, moreover, columns in the table3 are defined with respect to table4 (based on id). This means that I have to fidle with 4 tables to insert records into one table and need to use quite long select statements. Could any of you advise me advanced SQL language manual specifically for MySQL?? This would be of GREAT help (General books do not help, I have several of them already...;-( Thank you a lot, Jan --------------------------------------------------------------------- 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