get non matching rows from table 2

[randomSql]

Hello,
I've been having trouble in getting proper results querying the following I have 2 tables T1 & T2, each of which has a single column C1. the data in each of the tables are as follows:
T1.c1
1
4
8
9
0
a
c
d
T2.c1
1
2
3
8
9

I would like the non matching rows only from T2, i.e I expect the results 2, 3 from T2. Any help to query the tables will be greatly appreciated.

[ck9663]

Hello,
I've been having trouble in getting proper results querying the following I have 2 tables T1 & T2, each of which has a single column C1. the data in each of the tables are as follows:
T1.c1
1
4
8
9
0
a
c
d
T2.c1
1
2
3
8
9

I would like the non matching rows only from T2, i.e I expect the results 2, 3 from T2. Any help to query the tables will be greatly appreciated.

try:
select * from t2 where c1 not in (select c1 from t1)

-- ck

[randomSql]

Thanks very much for your reply. I also tried using this and it worked , but yours seems simpler.
select t2.c1 from t2 except select t2.c1 from t2 inner join t1 on t1.c1=t2.c1