How to join tables using more than two columns

Hi Everyone, Could you please help me on the below questions

Could you please let me know if is it possible to join two tables by 2 or more columns as join columns.
Is it possible to join column using text column

Thanks
Pushpakumar




------------------------------
Pushpakumar Gnanadurai
------------------------------