SMSUG.ca

...your virtual communITy
Welcome to SMSUG.ca Sign in | Join | Help
in Search

Garth Jones

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"

Comments

No Comments

This Blog

Syndication

News

Training

Powered by Community Server (Non-Commercial Edition), by Telligent Systems