I am familiar with VB/Access programming but am new to PHP and MYSQL. I have created join SQL statements using Access and pasted them into PHP scripts that request data from MYSQL. Joins on 2 tables work fine but when I try joining 3 or 4 tables, PHP gives me a MYSQL syntax error. The queries run exactly as I would expect in Access.

Is there a dialect of SQL that MYSQL uses that Access users would be unfamiliar with?

If so, can someone give me a sample 3 and 4 table SQL join statement?