July 13th, 2013, 11:50 AM
Select updated rows from one table
There are two tables like I posted below.
I want a SQL query which selects all the rows from TABLE A which are not present in TABLE B. Also the select statement should pick all those rows which has updated value of COL_A2 in TABLE A.
The select statement should return following rows from TABLE A
I am not able to write a query for this. Can anyone help me ?? It will be of great help.
July 13th, 2013, 03:04 PM
ON tableb.col_b1 = tablea.col_a1
WHERE tableb.col_b1 IS NULL
OR tableb.col_b2 <> tablea.col_a2
July 14th, 2013, 10:43 AM
Thank You r937