Return information from different tables

How do I find information in a table where the data can be found in three different columns of a different table?

Example:

Table A [Column A]

Return for 'Table A [Column A]' the code z001, which can be in any of the columns of 'Table B':

Table B [Column A]
z002
z003
z001

Table B [Column B]
z004
z005
z007

Table B [Column C]
z008
z001
z009