I have been trying to perform a join with several tables and I am having no joy.
Can some one send me a query (just a select * is fine) for these tables the ID's i'm using below aren't the real column names but they will do for the purpose of this email. select * from table1 left join table2 on table1.id=table2.id table2 left join table3 on table2.id1=table3.id2 and table2.id2=table3id2 table3 left join table4 on table3.id3=table4.id3 table3 left join table5 on table3.id4=table5.id4 table3 left join table6 on table3.id5=table6.id5 table3 left join table7 on table3.id6=table7.id6 If someone can show me how write this type of query that would work on mysql, it would be greatly appreciated. We are moving our Access 97 DB's to Mysql (probably Mysql 4 with builtin support for InnoDB tables for row-level locking). SQL Server is too pricey for our needs. cheers, James O'Brien Senior Technical Analyst PowerConnex Pty Ltd --------------------------------------------------------------------- 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