Inner Join in SQL Server

Tables are

a userbasic

b userlmits

c groupauthclass

— 2 Table Inner Join SQL Server —


select a.userid,a.groupid,a.username,a.branch, b.onlinedebit,b.offlinedebit
from dbo.userbasic a join dbo.userlimits b on a.userid=b.userid ;

— 3 Table Inner Join SQL Server —


select a.userid,a.groupid,c.classid,c.authority, b.onlinedebit,b.offlinedebit
from dbo.userbasic a join dbo.userlimits b on a.userid=b.userid
join dbo.groupauthclass c on c.groupid=a.groupid;

Advertisements