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;