Hi, this is probably a simple query but I tried all I can think of without finding a
solution.
I have three tables,
CREATE TABLE Answer (
AnswerID INTEGER NOT NULL AUTO_INCREMENT,
QuestionID INTEGER NOT NULL,
Value DECIMAL(15,4) NOT NULL,
AccountID INTEGER,
PRIMARY KEY (AnswerID)
)
PROTECTED]
Sent: Monday, August 19, 2002 10:35 AM
Subject: JOIN query with three tables.
Hi, this is probably a simple query but I tried all I can think of without
finding a solution.
I have three tables,
CREATE TABLE Answer (
AnswerID INTEGER NOT NULL AUTO_INCREMENT,
QuestionID INTEGER
= c.AccountID), Person p
where c.PersonID = p.PersonID
Best regards,
Mikhail.
- Original Message -
From: Nicolas Ivering [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, August 19, 2002 10:35 AM
Subject: JOIN query with three tables.
Hi, this is probably a simple query but I
:46 AM
Subject: Re: JOIN query with three tables.
Nicolas,
select a.AnswerID,a.QuestionID,a.Value,a.AccountID,p.FirstName,p.LastName
from Answer a left join Account c on (a.AccountID = c.AccountID), Person p
where c.PersonID = p.PersonID
Best regards,
Mikhail.
- Original Message
Ivering ;
Sent: Monday, August 19, 2002 10:46 AM
Subject: Re: JOIN query with three tables.
Nicolas,
select a.AnswerID,a.QuestionID,a.Value,a.AccountID,p.FirstName,p.LastName
from Answer a left join Account c on (a.AccountID = c.AccountID), Person p
where c.PersonID = p.PersonID
Best regards