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
Thanks for your reply. Unfortunately that query will not select rows
where Answer.AccountID is NULL which is what I wanted.
/Nicolas
Mikhail Entaltsev wrote:
>Nicolas,
>
>select a.AnswerID,a.QuestionID,a.Value,a.AccountID,p.FirstName,p.LastName
>from Answer a left join Account c on (a.AccountI
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 -
From: "Nicolas Ivering" <[EMAIL PROTECTED]>
To: <[EMA
