Joins

Question

Hi all!!

I have two tables

table1
                  C1
                  C2
                  C3
table2
                  C4
                  C5
                  C6


there is no unique column.
I want to get records corresponding to C2,C3 from table1 and C5 from table2
Which query i can use??