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
"bob8000" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
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
|
Similar Threads
