Hi all ,

I've got 2 tables : 1)Answers 2) Respondents

Those 2 tables contain 1 common fields 'RecID'.

Now my question is how can I filter the RecIDs from the table Answers who
are not in the table respondents?

Am I clear ?
A little summary: table Answers contains some RecIDs who are not in table
Respondents and I want to view them .

Thanks a lot !!!

On 21 May, 08:39, "Kulgan" <nos...@skynet.be> wrote:
> Hi all ,
>
> I've got 2 tables : 1)Answers 2) Respondents
>
> Those 2 tables contain 1 common fields 'RecID'.
>
> Now my question is how can I filter the RecIDs from the table Answers who
> are not in the table respondents?
>
> Am I clear ?
> A little summary: table Answers contains some RecIDs who are not in table
> Respondents and I want to view them .
>
> Thanks a lot !!!

SELECT
`a`.`RecID`
FROM `Answers` `a`
LEFT JOIN `Rrespondents` `r` USING(`RecID`)
WHERE `r`.`RecID` IS NULL