Select from where 1

[straatlang]

Hi,

Maybe someone can help me out with the following.

I have to tables I need to know the missing numbers.

Table A

NRA
1
1
2
2
2
3
3
4
4
5
5
7
7
7
7


Table B

NRB
2
2
2
3
3
3
3
5
I would like to see which number is not present in B

the result should be shown ones
so the result should be 1,4 and 7

 

[swampBoogie]

select distinct nra from tablea
where nra not in (select nrb from tableb)

 

[straatlang]

Thank you very much it works perfectly