This is a discussion on Access to MySQL conversion within the MySQL Database forums, part of the Database Forums category; Can anybody help me to convert an Access query in to a MySQL query statement PLEASE Access Query 10a is: ---------------------------------------------------------------------------*---------------------------------- ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
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_I D 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 |
![]() |
| Thread Tools | |
| Display Modes | |
|
|