SQL Select Statement Help..

Hi Guys,

I am currently running a SQL server using MySQL. I have multiple tables in this database and I am trying to use a select to join these tables together.

The select statement I am using in MySQL Works and this is it here:

Please Login or Register  to view this content.

VBA Statement

Please Login or Register  to view this content.

However I am having some translation issues getting this to work in VBA (Excel)

Once I try open the recordset the connection crashes as theres some syntax errors in my statement.

If you could you please point me out as to where I've gone wrong with this statement that would be much appreciated!

For all those who might also be struggling with a mySQL database the following link is a great read: http://www3.ntu.edu.sg/home/ehchua/p..._Beginner.html

From this website the "More than One Table" Chapter is where I learnt how to retreive data accorss multiple tables.