Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pamyral_279
Posting Yak Master
143 Posts |
 Posted - 2009-09-14 : 00:17:08
|
| I have five tables(User,Usergroup,group,permission,permissiongroup)User ---------->Usergroup <---------- Group Permission----->Permissiongroup <---- GroupUsers are in one or more groups.Permsisions are in one more groups.Now my task is show that all permissions of users !User(Uid,username,password)Usergroup(ugid,uid,gid)Group(gid,groupname)Permission(pid,permission)PermissionGroup(pgid,pid,gid)Any one help me ! thanks very much |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
pamyral_279
Posting Yak Master
143 Posts |
Posted - 2009-09-14 : 02:57:46
|
quote:
Originally posted by tkizer
Here is an example of a multi-table join, apply it to your situation:SELECT t1.column1, t1.column2, t2.columnA, t3.someColumnFROM Table1 t1JOIN Table2 t2ON t1.column1 = t2.column1JOIN Table3 t3ON t2.columnA = t3.ColumnA...Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong."
Yeah ! Thank you very much.That's everything i want ... :) |
 |
|
|
|
|
|
|
|
join 5 tables!