Multi-part identifier error

[jmprescott]

Clearly, I don't really know what I'm doing here, but I'm trying to create a stored procedure to grab the top 20 URLs from one table and plug it into another table (along with some other info)

I'm getting an error:

Msg 4104, Level 16, State 1, Procedure GETASSIGNMENTS, Line 2
The multi-part identifier "ArmyRootURLPag es.DateReviewed " could not be bound.

CREATE PROCEDURE GETASSIGNMENTS AS
UPDATE TOP (20) AssignedPages
SET AssignedPages.PageURL = ArmyRootURLPages.PageURL, RoleID = [Form_ArmyWebPages].roleid, PageType = 1
WHERE ArmyRootURLPages.DateReviewed is Null

Anyone know what I'm doing wrong?

Thanks

[ck9663]

Are you updating or inserting?

--- CK

[jmprescott]

Inserting, :(

Figured it out, thanks