You have a syntax error in your SQL statement below, it should read "SELECT max(people.version) AS Lastversion, addr.name FROM people, addr REGHT JOIN addr ON people.ID = addr.ID GROUP BY "add.name;"
You have to call out both tables in your SQL statement. Then it might work. Curtis Chris Carter said: > MySQL just does not support some features: > "SELECT Max(people.version) AS Lastversion, addr.name FROM people RIGHT > JOIN addr ON people.ID = addr.ID GROUP BY addr.name;" > > Will not work in Mysql; this sql statement I used in M$SQLServer > required creating a temporary table in Mysql and then running another > query from the temporary one to get the answer (not sure about > PostgreSQL). > > ADODB is a wonderful tool (use it all the time), but I think it does not > write SQL statements (yet). > > Cheers! > Chris > >> -----Original Message----- >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] On Behalf Of Ted Rolle >> Sent: 05 November 2003 23:35 >> To: Dbmail mailing list >> Subject: RE: [Dbmail] diff between 1.x and 2.x and other questions >> >> >> It IS possible to write code that requires a one-statement >> change to run on PostgreSQL or MySQL. >> >> However, ADODB adds overhead of its own. >> >> Whatever... >> _______________________________________________ >> Dbmail mailing list >> [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail >> > > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail
