Stored Procedure Problem

[Rajahar]

Im having two databases in these two databases containing same tables and stored procedures
In that while execting one of the stored procedures in both databases getting different records
I want records of data which are not in another database
Thanks in advance

[amitpatel66]

Im having two databases in these two databases containing same tables and stored procedures
In that while execting one of the stored procedures in both databases getting different records
I want records of data which are not in another database
Thanks in advance

Create a dblink to another database
then try this query:

[code=sql]

SELECT * from table1 WHERE column1 NOT IN (SELECT * FROM table1@dbase2)

[/code]

[ck9663]

Use a fullname to refer to your table

SELECT * FROM db1..table1 WHERE column1 NOT IN (SELECT * FROM db2..table1)

-- CK