compare two tables records using cursour

itsdba · #1 (**permalink**) 12-30-09, 16:42

I have 2 tables having one common coloumn in both. How can I comapre that the both col conatin same value or not. How can I do this using cursor?
If any other way to resolve this

Please help me on that.

r937 · #2 (**permalink**) 12-30-09, 18:55

let's say your two tables are called table1 and table2, and the column that they have in common is called columnx

this query compares the rows without a cursor --

Code:

SELECT table1.columnx
     , table2.columnx
  FROM table1
FULL OUTER
  JOIN table2
    ON table2.columnx = table1.columnx
ORDER
    BY COALESCE(table1.columnx,table2.columnx)

Internet Services

Web Development

Digital Marketing

Consumer Tech