Come confrontare il contenuto di due collections

  • Article

Select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,

SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_R_System.ResourceId

not in (select sys.resourceid from sms_cm_res_coll_COLXXXXX AS coll, sms_r_system as sys where sys.resourceid = coll.resourceid) and SMS_G_System_SYSTEM.ResourceID in

(select sys.resourceid from sms_cm_res_coll_COLYYYYY  AS coll, sms_r_system as sys where sys.resourceid = coll.resourceid)

Dove: COLXXXXX è la collection con un numero di oggetti minore rispetto alla collection COLYYYYY