A sytax question
-
I have two SELECTs and I want to merge their results using an inner join. Then, I want to insert it into a table... I tried INSERT INTO tableName SELECT * FROM ((SELECT blah blah blah ) as numberOne LEFT JOIN (SELECT blah blah blah ) as otherTable on numberOne.index = otherTable.index )) I get a syntax error though, so what am I doing wrong? Thanks a lot, Jim Did I post well? Rate it! Did I post badly? Rate that too!
-
I have two SELECTs and I want to merge their results using an inner join. Then, I want to insert it into a table... I tried INSERT INTO tableName SELECT * FROM ((SELECT blah blah blah ) as numberOne LEFT JOIN (SELECT blah blah blah ) as otherTable on numberOne.index = otherTable.index )) I get a syntax error though, so what am I doing wrong? Thanks a lot, Jim Did I post well? Rate it! Did I post badly? Rate that too!
Esmo2000 wrote: I get a syntax error though, so what am I doing wrong? What does the syntax error say? Also, please post the exact code you used because "blah blah blah" is not going to help - the SQL Parser won't accept it.
My: Blog | Photos | Next SQL Presentation WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More