tiger

I'm trying to write a query and I'm having some problems getting it to do what I want.

I want to compare columnA.commenter_id to all the values in columnB.user_id
if there is no columnA.commenter_id that corresponds to a columnB.user_id
then set columnA.commenter_id to = 999999.

Thanks in advance.

__________________