Then JOIN them

select x.R1,x.R2,x.R3, y.C1,y.C2,y.C3

from Database.table1 as x

join Database.table2 as y

to get all possible combinations aka cartesian product.

Restrict combinations using WHERE clause

http://technet.microsoft.com/en-us/library/ms191517(v=sql.105).aspx