INSERT INTO tblRelief_Allot ( EmpId )
SELECT tblEmpDetails.EmpId
FROM tblEmpDetails;
I need to INSERT INTO (EmpID, ReliefCode, GRating)
Only the EmpID is from a table I want ReliefCode, and GRating to be values 28, 1
How could I Write the Query to INSERT INTO (EmpID, ReliefCode, GRating)
from the table and values?