I just need to know if it can be done with join tables
Is it possible for dataAssit to create a search page to search either by customer ID or customer NAME? I have joint customer table to quote table.
Customer Table
customerID (primary key)
customerName
Quote Table
quoteID (primary key)
customerID (foreign key)
QUERY
---------------
SELECT quotes.quoteID, quotes.customerID, customers.customerName
FROM quotes
LEFT OUTER JOIN customers ON (quotes.customerID = customers.customerID)
Can you please point me in the right direction where I can make the adjustment.