I want to query our
I have a backup of
CRM Db and the existing one.
There is a
custom entity,in both of them I have created.
Some of my custom entity records has deleted from the existing db.
I want to compare which records has deleted.
Number of existing records is 17 and the backup contains 19 records.
The custom entity is named
The backup database is named
test2 and the existing one is
MSCRM The table name is
When I query this equal ones :
select * from test2.dbo.new_services as t1, MSCRM.dbo.new_services as t2 where t1.new_service_Id = t2.new_service_Id;
And return correct records, But when I try this :
select * from test2.dbo.new_services as t1, MSCRM.dbo.new_services as t2 where t1.new_service_Id != t2.new_service_Id;
It returns 308
The new_service_id is the guid of the record.
Where is wrong?