Code Forums - View Single Post

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.

06-09-2005, 07:44 AM	#2 (permalink)
jeffro Person of interest Join Date: Mar 2003 Location: New Jersey Posts: 102	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. __________________ Jeffro Linux counter#:213782 GnuPG ID: 406238E7