<div>
If you are 100% sure a user has only 1 company<br />

<pre><code id="code-20-38010627-1">WHERE [CompanyID] = 
 (select OwnCompanyID 
 from dbo.tableUserCompany  -- change tablename to the one in your database
 where UserName = @UserName
) </code></pre>
But more safe <br />

<pre><code id="code-20-38010627-2">WHERE exists  
 (select 1  
 from dbo.tableUserCompany  as uc -- change tablename to the one in your database
 where uc.UserName = @UserName
 and  uc..[CompanyID] = [Users].[CompanyID]
) </code></pre>
</div>


If you are 100% sure a user has only 1 company


WHERE [CompanyID] = 
 (select OwnCompanyID 
 from dbo.tableUserCompany  -- change tablename to the one in your database
 where UserName = @UserName
) 

But more safe


WHERE exists  
 (select 1  
 from dbo.tableUserCompany  as uc -- change tablename to the one in your database
 where uc.UserName = @UserName
 and  uc..[CompanyID] = [Users].[CompanyID]
) 

<div>
<div class="content wysiwyg-content">
Dear Experts,<br />
<br />
I need to have a where statement similar to below, but I am not able to get it to work.<br />
<br />
Can you please help me with this one.<br />
Thanks, MB<br />
<br />
DECLARE @UserName as varchar(59)<br />
SET @UserName ='mb'<br />
<br />
SELECT [UserID], [UserName], [FullName], [Password], [UserAccessID], [CompanyID], [UserRole] , [OwnCompanyID]<br />
FROM [Users]<br />
WHERE [CompanyID] <b>= OwnCompanyID of @UserName</b>
</div>
</div>


Dear Experts,

I need to have a where statement similar to below, but I am not able to get it to work.

Can you please help me with this one.
Thanks, MB

DECLARE @UserName as varchar(59)
SET @UserName ='mb'

SELECT [UserID], [UserName], [FullName], [Password], [UserAccessID], [CompanyID], [UserRole] , [OwnCompanyID]
FROM [Users]
WHERE [CompanyID] = OwnCompanyID of @UserName

Select in select

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.