Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Apr 2009
    Posts
    5
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Why wont this work in MySql?

    I get this query in access:

    SELECT Descriptions.Description, Customers.FirstName, Customers.LastName, Manufacturers.Description, Contacts.Name, Contacts.Date, Contacts.Comment, Jobs.Reference, Jobs.PassWord, Jobs.StatusCNTR
    FROM Contacts INNER JOIN ((((Jobs INNER JOIN Customers ON Jobs.ClientCNTR = Customers.CNTR) INNER JOIN Descriptions ON Jobs.DescriptionCNTR = Descriptions.CNTR) INNER JOIN Models ON Jobs.ModelCNTR = Models.CNTR) INNER JOIN Manufacturers ON Jobs.ManufacturerCNTR = Manufacturers.CNTR) ON Contacts.JobCNTR = Jobs.CNTR
    WHERE (((Jobs.Reference)='700400971'));

    But it will not work in mysql database with the same tables data ect

    Does anybody know what i have to change?

    Regards,
    Justin

  • #2
    New to the CF scene
    Join Date
    Apr 2009
    Posts
    5
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Never mind, it does work.

    Thanks anyway.

    Justin


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •