Not Equal To

[patelaashish]

Hi,

I have two tables as below with the respective columns in brackets:

TABLE1(A,B,C) and TABLE2(A,D,E,F)

I need find out all the A in TABLE2 which are "NOT EQUAL TO"
listed

Can somebody please help me with this query?

Thanks,

Aash.

[rmiao]

select * from table where col <> value

[MAK]

if u r looking for values of column A in table 2 not listed in table1 then

select * from table2 where A not in (select A from table1)

if u just looking for the string "not equal to" then

select * from table2 where A ='not equal to'
or
select * from table2 where A like '%not equal to%'