Skip to content

Instantly share code, notes, and snippets.

@afnanenayet

afnanenayet/Demo

Last active August 29, 2015 14:19
Show Gist options
  • Save afnanenayet/90b820796eaeba071991 to your computer and use it in GitHub Desktop.
Save afnanenayet/90b820796eaeba071991 to your computer and use it in GitHub Desktop.
Download ZIP
Business Server Stuff
Raw
Demo
/*Items originating from org*/
select ItemId, ItemDescription from Items where ItemOriginalOrgId = 279;
/*Those with roles in org*/
select RoleId, AcctId from Roles where OrgId = 279;
/*Items purchased from org and those who ordered them*/
select Details.DItemId, Details.DItemDescription, Orders.OId, Orders.OAcctId, Orders.OBillTo from Orders join Details on OId=DOId where OAcctId=326 order by DItemId;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment