Return information from different tables

[marcosvcortes]

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

[daXtreme · Accepted solution]

Your question is unclear. If you want a specific code... why would you want to look it up if you already know it? Secondly, you should consolidate the tables into one. Then you won't have problems.