Access to MySQL conversion

[bob8000]

Can anybody help me to convert an Access query in to a MySQL query
statement PLEASE

Access Query 10a is:
-------------------------------------------------------------------------------------------------------------
SELECT Customer.Cust_ID, Customer.Name,

EquipmentCategory.Category_Name
FROM EquipmentCategory INNER JOIN (Customer INNER JOIN

Equipment ON Customer.Cust_ID = Equipment.Cust_ID) ON

EquipmentCategory.Category_ID = Equipment.Category_ID
WHERE (((EquipmentCategory.Category_Name)="commercial"));
-------------------------------------------------------------------------------------------------------

Access Query 10b is:
---------------------------------------------------------------------------------------------------------
SELECT Customer.Cust_ID, Customer.Name,

EquipmentCategory.Category_Name
FROM EquipmentCategory INNER JOIN

(Customer INNER JOIN Equipment ON

Customer.Cust_ID=Equipment.Cust_ID) ON

EquipmentCategory.Category_ID=Equipment.Category_ID
WHERE

(((EquipmentCategory.Category_Name)<>"Commercial"));

---------------------------------------------------------------------------------------------

Query 10a just does the oppersite to Query 10b, that is all
NOW Query 10c uses Query 10a and 10b to achive my final query results

------------------------------------------------------------------------------------------------
SELECT Query10a.Cust_ID, Query10a.Name,

Query10a.Category_Name
FROM Query10a LEFT JOIN Query10b ON Query10a.Name

= Query10b.Name
WHERE (((Query10b.Name) Is Null));
---------------------------------------------------------------------------------------------------


So how would I tranfer all that in to a MySQL statement

Thanks

BOB8000