Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!
SELECT DISTINCT c.ProductID AS Product_ID, c.ProductName AS Product_Name, ProductSuppliers.SupplierName AS Product_Supplier, AccountOutlets.Outlet_ID, ProductSuppliers.SupplierId, pg.GroupOrderable, @Username as Username, c.Group_ID, OutletList.Territory_ID FROM AccountOutlets INNER JOIN ClientAccounts AS a ON AccountOutlets.Account_ID = a.Account_ID INNER JOIN OutletList ON AccountOutlets.Outlet_ID = OutletList.Outlet_ID RIGHT OUTER JOIN Products AS c INNER JOIN ProductGroups pg ON pg.GroupID=c.Group_ID INNER JOIN ProductSuppliers ON c.SupplierID = ProductSuppliers.SupplierID LEFT OUTER JOIN AccountOutletProducts AS aocf ON c.ProductID = aocf.Product_ID AND aocf.Account_ID IN (SELECT Account_ID FROM @OutletList) ON a.Account_ID = aocf.Account_ID WHERE (AccountOutlets.Outlet_ID IN (Select Outlet_ID FROM @OutletList)
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.