Logo Medical Science Monitor

Call: +1.631.470.9640
Mon - Fri 10:00 am - 02:00 pm EST

Contact Us

Logo Medical Science Monitor Logo Medical Science Monitor Logo Medical Science Monitor

01 June 2005 : Research paper

Domenico Mastrangelo, Cosimo Loré

Med Sci Monit 2005; 11(6): LE3-3 :: ID: 16515

SELECT `JOUR_WWW_AUTHORS_AFFILIATIONS`.* FROM `JOUR_WWW_ARTICLES` INNER JOIN `JOUR_WWW_AUTHORS` ON (`JOUR_WWW_ARTICLES`.`ICID` = `JOUR_WWW_AUTHORS`.`ID_ARTICLE`) INNER JOIN `JOUR_WWW_AUTHORS_AFFILIATIONS` ON (`JOUR_WWW_AUTHORS`.`ID_AUTHOR` = `JOUR_WWW_AUTHORS_AFFILIATIONS`.`idAuthor`) WHERE `JOUR_WWW_ARTICLES`.`ICID` = GROUP BY `JOUR_WWW_AUTHORS_AFFILIATIONS`.`department`, `JOUR_WWW_AUTHORS_AFFILIATIONS`.`institution` ORDER BY `SORT`
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY `JOUR_WWW_AUTHORS_AFFILIATIONS`.`department`, `JOUR_WWW_AUTHORS_A' at line 9