mysql> SELECT documents.id, documents.title, documents.description, documents.topics_id, documents.public, documents.date, documents.status, documents.owner_id, documents.template_id, templates.name, media.mime_type_id
-> FROM templates, documents LEFT JOIN media_uses ON media_uses.type_id=documents.id
-> LEFT JOIN media_description ON media_description.id=media_uses.media_description_id
-> LEFT JOIN media ON media.id=media_description.media_id
-> WHERE (documents.org_id=413) AND
-> documents.template_id = templates.id
-> ORDER BY documents.id ASC;
<snip>
17 rows in set (0.01 sec)
mysql>
But, when I run this in Witango I get an error:
1064. [MySQL][ODBC 3.51 Driver][mysqld-3.23.58]You have an error in your SQL syntax near ';
' at line 7
-101. General error during data source operation.
-101. General error during data source operation.
Any ideas??
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
