General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Comparing two SQL cursors
I have pulled data from two separate SQL tables, and I need to find which rows are different. They have exactly the same structure.
I have the two views which I will call cFirstSQL and cSecondSQL and I did the following thinking that this would work;
SELECT * from cFirstSQL WHERE NOT EXSISTS (SELECT * FROM cSecondSQL)
I get not data, and there are differences.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only