join sets flag when match = true

Dear all,

I have two tables:

Table A

with column A1, A2 and Flag

Table B

with column B1, B2

join = table A.A1 with table B.B1

if match = true then A1.merker should be set to 1.

Any idea how to realize?

Thx for help!

Best regards,

Heinz