join tables in sql server

Accepted answer

Select sid,createdby, t1.name , modifiedby , t2.name From sub Left outer join base t1 on sub.createdby = t1.Id Left outer join base t2 on sub.modifiedby = t2.Id Also make sure to include With NOLOCK.

+1

Delpin Susai Raj10y ago

SELECT column_name(s)
FROM table1
JOIN table2
ON table1.column_name=table2.column_name;

0

Midhun Tp10y ago

Hi,

You can use inner join for the same. Use below query -

Select sid,createdby,b1.name as createdbyname,modifiedby,b2.name as modifiedbyname

From sub inner join base b1 on sub.createdby = b1.Id

inner join base b2 on sub.modifiedby = b2.Id order by sid

0

Bikesh Srivastava10y ago

Simple use inner join.

0