Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Join tables

Join tables

Thread began 11/02/2010 8:06 am by danny405167 | Last modified 11/02/2010 3:56 pm by danny405167 | 1961 views | 8 replies

11/02/2010 8:06 amdanny405167

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.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.