>Hello,
>I try to return key from table1 which has not reference in the table2.
>
>[Table1].key
>1
>2
>3
>
>[Table2].key
>1
>
>SELECT table1.key FROM table1 ;
> WHERE table1.key NOT IN (SELECT table2.key FROM table2)
>
>I want to query return
>[Query].key
>2
>3
>
>But I got nothing.... empty sql result.... why?
Are the key fields compatible - the same size?
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)