RE: [PHP-DB] MS Access and MySQL

2001-03-12 Thread Allsebrook_Richard/askr
BDY.RTF -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] MS Access and MySQL

2001-03-12 Thread Patrick Schäfer
This join works perfectly in Access but if I use the same query in MySQL it shits it's pants. SELECT [tbl_medien].[titel], [tbl_medien].[ausgabe], [tbl_medien].[URL], [tbl_medien].[medientypID], [tbl_autor].[name], [tbl_autor].[vorname] FROM tbl_medien INNER JOIN (tbl_autor INNER JOIN tbl_zuordnu