| Finding the common records [message #372053] |
Mon, 08 January 2001 01:06 |
vijaya kumar
Messages: 3
Registered: January 2001
|
Junior Member |
|
|
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.
PLEASE ENSURE THAT THE QUERY RUNS BOTH ON ORACLE AND SQL-SERVER.
Thanking You and awaiting for your immediate response,
Regards,
Vijaya Kumar
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
