CREATE PROCEDURE [dbo].[usp_getData]
@userId VARCHAR(100)
AS
SELECT aUsers.userId, aUsers.firstName + \' \' + aUsers.lastNAme AS name, aAccounts.accountName
FROM aUsers INNER JOIN
aUserAccounts ON aUserAccounts.userId = aUsers.userId INNER JOIN
aAccess ON aAccess.accessLevel = aUserAccounts.accessLevel INNER JOIN
aAccounts ON aAccounts.accountId = aUserAccounts.accountId
WHERE aUsers.userId = @userId
GO