Hi,

I have a Sales database. There is a table for customers and a table for Sales.
There is a Customer field in the Sales table which holds the ID from the Customer table. This is then Left Join in the queries to get the associated customer's name.

The problem is that now there can be multiple customers per Sales record. So the Customer field is now text holding the various customer IDs.
I'm struggling to adjust the query so that I can replace a text field holding the customer IDs (1,2,3 etc) with the associated customer names from those IDs.


The statement can't work as the ID does not equal the Sales value and the data types are different.

PHP Code: 
 LEFT JOIN Customers ON Customers.[ID] =  tbSales.[Customer