Home » RDBMS Server » Server Administration » Finding the common records
Finding the common records [message #372052] |
Mon, 08 January 2001 01:04 |
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.
Thanking You and awaiting for your immediate response,
Regards,
Vijaya Kumar
|
|
|
Goto Forum:
Current Time: Sat Jan 11 04:25:17 CST 2025
|