If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access to MySQL conversion
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 | |
|
|