ASP ADO SQL Query

TheShadow · 05-25-2005, 08:57 PM

I'm having trouble thinking how to write a query ... i have two tables customer and contact ...they share a common element of customerID ... their is a login form based on the contactID, contactPassword within the contact table, based on that i want the contactID and customerID of contact, to display the fields of the customer table ...

Anyone keep up with that?

jeffro · 06-09-2005, 07:44 AM

This should get you what you need:

Code:

select t1.*
from customer t1, contact t2
where t1.customerID = t2.customerID
and userInput_ID = t2.contactID
and userInput_Password = t2.contactPassword

Please (anyone), feel free to comment, as my SQL isn't what it could be. ;-) BTW, t1.* probably won't work, its just pseudo code, for any columns in customer you want.

redhead · 06-09-2005, 09:01 AM

perhaps something like this:

Code:

SELECT * FROM customer WHERE customerID IN (SELECT customerID FROM contact WHERE userInput_ID = contactID AND userInput_Password = contactPassword)