Lookup values from more than one table

I have three tables based on the compability i have to brought the date from another two tables like if match date from one table if mismatch the date from another table. Plz Help