I have an asp where I am trying to do a search. Example, I have a form in which you can search for all customers in the state of WA and whom have Blue Shield insurance or whatever you want to search for.
The search needs to look in two tables, therefore I am doing a join shown below. I cannot get this to work. It works fine until I throw in the join. Can anyone help? thanks
MyQuery = "select c.customerid, customer.firstName, customer.lastName, customer.address1, customer.city, customer.state, insurance.insurancename from customer, insurace where customer.customerid = insurance.customerid " & csSearch & "order by lastName, firstName, state, city"