RE: JOIN in SQL Query

2001-12-21 Thread Roger Baklund
* 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,

JOIN in SQL Query

2001-12-21 Thread 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