You guys helped me out about a year ago with a similar problem. Since then I made some changes and now am getting this error: "Msg 4104, Level 16, State 1, Line 5 The multi-part identifier "rc_yea.yesvoters" could not be bound."
Can you spot the issue? Thanks in advance.
INSERT INTO dbo.RollCallsIND1112
(district_id, member_name, RCID, result)
SELECT dbo.Members.Dist, dbo.Members.AlphaShort, dbo.RollCalls.PKRCID, 'Y' AS Yea
FROM dbo.Members INNER JOIN
dbo.rollcalls ON rc_yea.yesvoters LIKE '%' + dbo.Members.AlphaShort + '%'
where is the condition in ur query? look at the last line of ur query, you have written inner join but where is the conditon. Condition should be like table A inner join table B on tableA.xyz = tableB.xyz
provide a condition in your query or a column / field which is common in both the tables.