Update Query using Condition (1 Viewer)

[Drunkenneo]

I have a table

Main

Name Inter Intra Flag
------------------
A BB CC
as DD FF

And Table

Code table:

code Flag
----------
BB 1
CC 0
DD 0
FF 0


All the Flag reference taken from table, I want an update query where it checks if either of Inter and intra from Main table have flag as 1 from code table, it should update the flag in main as 1 else 0.

Could this be possible?

 

[namliam]

Something along these lines:
Select main.*, inter, codeinter.flag, intra, codeintra.flag
From Main
Join Code as codeInter on inter = codeinter.code
join Code as CodeIntra on intra = codeintra.code