We are used to doing things in Access, but have moved to MySQL because we are growing and it is is more flexible.
I am trying to write some MySQL queries to take the place of Access Queries we used to use. This one gives me an error in MySQL. Can someone point me in the right direction?
SELECT weborders.OrderID, weborders.CustomerID, customerwebid.[Customer Name], customerwebid.[Bank Name], [customer list].Address
FROM (weborders LEFT JOIN customerwebid ON weborders.CustomerID = customerwebid.[Customer ID]) LEFT JOIN [customer list] ON customerwebid.[Bank Name] = [customer list].[Bank Name]