IE7 Collection

For full detail please see forum post

 

select 
    *  
from  
    SMS_R_System 
    left join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId 
    left join SMS_G_System_ADD_REMOVE_PROGRAMS_64 on SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceId = SMS_R_System.ResourceId 
where 
    SMS_G_System_ADD_REMOVE_PROGRAMS.ProdID = "ie7" 
    or SMS_G_System_ADD_REMOVE_PROGRAMS_64.ProdID = "ie7"

Leave a Reply

Your email address will not be published. Required fields are marked *