>Please see my reply to Borislav. I didn't mention in my initial message that I want the records from the Table2 that do not have matching to Table1 to be included in the resulting query as well.

I just saw it and already answered.

Can you better explain what do you want with the samples of the records? If you want matching and non-matching, you use LEFT JOIN.
If you want to find non-matching only, use NOT EXISTS subquery.