ASP ADO SQL Query

[TheShadow]

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]

This should get you what you need:

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]

perhaps something like this:

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