manuel joseph

manuel joseph

  • 1.5k
  • 154
  • 204.6k

sql server

Aug 26 2012 7:02 AM

Hi, 
     I have two table Employee,Phone how get only empid and phone number with distinct phone number below table

Employee
empid  name 
1         siva
2         jose 
3         ramya 


------

Phone

empid   phone

1 9960076000
8860076000 
7760076000 
9160076000 
9060076000 
9060076000 



Answers (3)