Select value from either of two tables in PostgreSQL (foreign_key and direct)?

I need to check for a value in either table_one or table_two.