gt;:)
>
>Best regards,
>Mikhail.
>
>
>
>- Original Message -
>From: "Mikhail Entaltsev"
>To: "Nicolas Ivering" ;
>
>Sent: Monday, August 19, 2002 10:46 AM
>Subject: Re: JOIN query with three tables.
>
>
>
>
>>Nicolas,
>&
>;
<[EMAIL PROTECTED]>
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), Pers
Account c on (a.AccountID = 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
ROTECTED]>
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 tried all I can think of without
finding a solution.
>
> I have three tables,
>
> CREATE TABLE Answer (
>
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)
) T
