ASP ADO SQL Query

TheShadow · May 26th, 2005, 12:56 AM

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?

Webforumz Staff · May 26th, 2005, 03:09 AM

Code:

SELECT contact.contactID, contact.contactPassword, customer.* FROM contact INNER JOIN customer ON contact.customerID = customer.customerID

TheShadow · May 26th, 2005, 05:37 AM

Isnt that for all Customer ID?

What would you have to do for a particular Customer ID...

D3mon · May 26th, 2005, 05:44 AM

Add:

Code:

where customerID = ...

TheShadow · May 26th, 2005, 05:53 AM

Quote:

Originally Posted by D3mon

Add:

Code:

where customerID = ...

But thats part of the problem ...

... we input the contactID, and therefore its the corresponding customerID ... but how do we write that?

Trebz · May 26th, 2005, 10:03 AM

Is it this simple

Code:

SELECT
	Col1,
	Col2,
	etc
FROM contact X
	JOIN customer Y
		ON x.CustomerID = y.CustomerID
WHERE X.ContactID = 'blah'

TheShadow · May 27th, 2005, 12:34 AM

Quote:

Originally Posted by Trebz

Is it this simple

Code:

SELECT
	Col1,
	Col2,
	etc
FROM contact X
	JOIN customer Y
		ON x.CustomerID = y.CustomerID
WHERE X.ContactID = 'blah'

Code:

SELECT *
FROM contact
	JOIN customer
		ON contact.CustomerID = customer.CustomerID
WHERE contact.ContactID = Request.form("username")

... like that?

TheShadow · May 27th, 2005, 12:39 AM

I guess not ... doesnt return any values ....

Trebz · May 30th, 2005, 06:30 AM

Could you maybe explain the question a little clearer please, I can't quite understand what you need.

Cheers

Rob · May 30th, 2005, 06:32 AM

I have to say, I'm a little confused too... :S

HostBreak · June 18th, 2005, 12:12 PM

Quote:

Originally Posted by rob

I have to say, I'm a little confused too... :S

Me Too!