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?

[Webforumz Staff]

Code: Select all

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

[TheShadow]

Isnt that for all Customer ID?

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

[D3mon]

Add:

Code: Select all

where customerID = ...

[TheShadow]

Originally Posted by D3mon

Add:

Code: Select all

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]

Is it this simple

Code: Select all

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

[TheShadow]

Originally Posted by Trebz

Is it this simple

Code: Select all

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

Code: Select all

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

... like that?

[TheShadow]

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

[Trebz]

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

Cheers

[Rob]

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

[HostBreak]

Originally Posted by rob

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

Me Too!