HI,
I have two tables.I want to retrieve the uncommon records from two tables.
I m using the queries :
select col1,col2 from table 1
where rtrim(col1+'-'+col2) not in
(select rtrim(col1+'-'+col2) from table 2)
i have used this query also :
select rtrim(col1+'-'+col2+'-'+col3+'-'+col4) from table 1
except
select rtrim(col1+'-'+col2+'-'+col3+'-'+col4)...