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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-10 : 00:04:24
|
Vijaya Kumar writes "I have table by name Previleges as follows with two columns viz., Supplier and Service and is stored as follows
Privilege Table
------------------------
Supplier Service
------------------------
Sup1 login
sup1 home
sup1 mypage
Sup2 login
sup2 home
Sup3 login
sup3 mypage
Could you please formulate SQL Query in order to retrieve the list of Services common to all the three(or what ever no. of i select dynamically) suppliers.
Thanking You and awaiting for your immediate response,
Regards,
Vijaya Kumar" |
|
|
|
|
|
Please send me a Query and help me out!