比较2个表中的每一行

I have 2 tables. Tables are having same colums and I need to compare them. Simple Join query cannot resolve my problem 'cause table2 can contain many rows appropriate to table 1, but I need to choose the best appropriate row. For example : I have 2 tables. Tables are having same colums