Query to show Account Number with Zones

SELECT
(Select AccountNumber from AccountMain where ID = AccountID) AS AccountNumber,
AccountZone.*
FROM [SIMSData1].[dbo].[AccountZone] where TestEvery != 0
Was this article helpful?
Thank you for your feedback!
User Icon

Thank you! Your comment has been submitted for approval.