Join tables
I have 2 tables, customers and quotes. I have joined the customers table with my quote table. Below is the query that I am using.
SELECT quotes.quoteID, quotes.customerID, customers.customerName
FROM quotes
LEFT OUTER JOIN customers ON quotes.customerID = customers.customerID
I get the following error "Column 'customerID' in where clause is ambiguous" when I searched by either customer ID or customer name. I tried using Includes, Begin with, and = from dataAssist wizard when creating the search form.
I am only getting the error when I used the LEFT OUTER JOIN clause.