query to combine the employee information from two tables Emp and History

Bandi
Posted by Bandi under Sql Server category on | Points: 40 | Views : 225
SELECT EMP.*,HISTORY.* 
FROM EMP
JOIN HISTORY ON EMPNO=EMPID

Comments or Responses

Login to post response