Table A) a b c1
a b c2
a b c3

Table B) a b d1
a b d2
a b d3

the expected out put is

a b c1 d1
a b c1 d2
a b c1 d3
a b c2 d1
a b c2 d2
a b c2 d3
...
..
As these to tables are independent , you may not be able to get your desired result.

If your tables looked like this,
col1 col2
-------------------------------
Table A) a1 c1
a2 c2
a3 c3
a4 c4



Table B) a1 d1
a2 d2
a3 d3


select a.c1,a.c2,a.c3,b.c4
from tab A a, tab B b
where a.col1 = b.col1(+)



Badrinath