sql query to compare

[Deam]

I am trying to create a stored proc that would compare the value entered by a user with the value in another table.
There are two tables Table_a(PersonID,ALocationCode,AFlag) and Table_b(PersonID,BLocationCode)
If the ALocationCode entered by the user is not equal to the BLocationCode then AFlag needs to be checked. I am new to this...any help is appreciated.

 

[Andel]

Try this one...

update Table_a
set AFlag = 'YES' -- or set to TRUE, whatever you want
where PersonID IN (
select B.PersonID
from Table_A A, Table_B B
where A.PersonID = B.PersonID and
A.ALocationCode <> B.ALocationCode
)
Andel
andelbarroga@hotmail.com

http://andyb.8m.com

 

[Guest_imported]

I don't believe I understand what you want to do, but I think you might want to do it with a trigger for update, insert on Table_A vice a stored proc.