急求sql

Question

sql>>select field1 from tablename1field1 
--------------
aa
bb
cc
dd
ee
select field2 from tablename2field2 
--------------
11
22
33
求如下矩阵显示结果的SQL，3Q！
field1   field2 
-------  ----------
aa       11
aa       22
aa       33
bb       11
bb       22
bb       33
cc       11
cc       22
cc       33
......

Answer 1

select field1 from tablename1
union
select field2 from tablename2
union
....

Answer 2

select field1,field2 from tablename1,tablename2

Answer 3

select one.field1,two.field2 from tablename1 one,tablename2 two

Answer 4

select t1.field1,t2.field2 from tablename1 right join tablename2