Home Forums SQL Server 2008 SQL Server Newbies Problem with a query - wrong update results RE: Problem with a query - wrong update results
ryan.mcatee
SSC Eights!
Points: 860
More actions
March 5, 2013 at 7:56 am
#1593490
Change your query to:
SELECT A.final_owner, tblUser.tName, A._owner_m, cast(A._owner_m as int), tblUser.aUserID, cast(tblUser.aUserID as int)
FROM A INNER JOIN
tblUser ON cast(A._owner_m as int) = cast(tblUser.aUserID as int)
And post the results.