Sub Query in INSERT statement

[CB77]

How do you use a subquery to look up a value in another table to insert it into a new field?

[Phil Weber]

http://www.sqlteam.com/item.asp?ItemID=277

[CB77]

Thanks but that doesn't help me. This is what I am trying to do but get errors

INSERT INTO SportEmployee
(EmployeeLastName, EmployeeFirstName, EmployeeMI, EmployeeDOB, EmployeeManagerID, EmployeeHireDate, EmployeeHomePhone, EmployeePhotoFilename, EmployeeCommission, DepartmentID, EmployeeUserName, EmployeePassword)
VALUES ('Lee', 'Jim', 'R', 15/07/1977, (SELECT EmployeeManagerID FROM SportEmployee WHERE DepartmentID = 1), 30/6/2008, 7158889999, 'lee.jpg', 0.05, 1,'leej', '1j2k3k')

[Phil Weber]

Oh, yeah, you can't do that. :-) Why not run the SELECT query separately and save the result in a variable, then pass it to the INSERT statement along with the other values?

[CB77]

Thanks