...

View Full Version : Why wont this work in MySql?



jrsl
04-27-2009, 10:28 AM
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

jrsl
04-27-2009, 10:33 AM
Never mind, it does work.

Thanks anyway.

Justin



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum