Hi,
Please help me to solve this problem on Unix isql. Following is an example table and expected select result. I need to select NAMEs where those NAMEs don't have a record which TYPE='T1'. I tried, but got both N2 and N3.
NAME TYPE DATA
---------------------
N1 T1 D11
N2 T1 D21
N2 T2 D22
N3 T2 D32
output of the select:
NAME
-----
N3
Thanks