* Mats Lindblad > 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
If the =20 and =3D was there before you sendt your email, that might be your problem. To fix it: replace =20 with a space, remove = when it is at the end of the line, and change =3D to =. Otherwise it looks ok, but that depends on the descriptions of your tables. It would be easier to answer if you posted the error message, and maybe also the output of "desc stundents;" and "desc grupper;". -- Roger --------------------------------------------------------------------- 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
