I can't get this JOIN to work in my SQL-QUERY as it is supposed to! Could someone check the syntax to se if I missed something?
SELECT students.pnr, students.firstname, students.lastname, students.email,= =20 students.grupp, students.info, students.lastmod AS lastmod,=20 grupper.courseID, grupper.dag, grupper.tidpunkt, grupper.antal,=20 grupper.lastmod FROM grupper LEFT JOIN students ON grupper.courseID =3D=20 students.grupp WHERE grupper.courseID =3D students.grupp order by=20 grupper.courseID ASC MVH Mats Lindblad Webbutvecklare och Serviceadministratör Enheten för IT och media Webb och grafisk produktion Tel: +46 8 674 74 66 http://www.it.su.se/ http://www.su.se --------------------------------------------------------------------- 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