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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s