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

 

[Larry Daugherty]

Do you also post your Access issues in the MySQL newsgroups?

--
-Larry-
--

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

 

[User]

You would probably use nested select statements instead of creating the
intial queries 10a and 10b. Like...

SELECT Query10a.Cust_ID, Query10a.Name, Query10a.Category_Name
FROM (<<first query>>) as Query10a
LEFT JOIN (<<second query>>) as Query10b
ON Query10a.Name= Query10b.Name
WHERE (((Query10b.Name) Is Null));

Does that work in mySQL?

Doug


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