Access to MySQL conversion

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: ---------------------------------------------------------------------------*---------------------------------- ...


Go Back   Usenet Forums > Database Forums > MySQL Database

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 12-13-2006
bob8000
 
Posts: n/a
Default 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

Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 03:37 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.0.0