INSERT INTO with SELECT statement error 1

[ksbigfoot]

Can someone see what I am doing wrong here?

I am getting an error
"Syntax error. in query expression 'SELECT 91 AS WOSubTasksID'"

Here is my query statement:

INSERT INTO dbo_WOSubTasksAssigned (WOSubTasksID, WOTaskListID, WOAssignedToID) VALUES (SELECT 91 AS WOSubTasksID, WOTaskListID, 10 As WOAssignedToID FROM dbo_AutoWOTaskList WHERE AutoWOServicesID = 2)

Thanks

 

[PHV]

INSERT INTO dbo_WOSubTasksAssigned (WOSubTasksID, WOTaskListID, WOAssignedToID)
SELECT 91, WOTaskListID, 10
FROM dbo_AutoWOTaskList
WHERE AutoWOServicesID = 2

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ksbigfoot]

Howdy PHV, Very nice, worked perfectly.
Star to you.
Thanks again,
ksbigfoot