mysql中有如下表tempid
------------
aaa
bbb
ccc怎么写一个sql语句 查询后得到如下结果,类似笛卡尔积id
------------
aaaaaa
aaabbb
aaaccc
bbbaaa
bbbbbb
bbbccc
cccaaa
cccbbb
cccccc多谢各位!!
------------
aaa
bbb
ccc怎么写一个sql语句 查询后得到如下结果,类似笛卡尔积id
------------
aaaaaa
aaabbb
aaaccc
bbbaaa
bbbbbb
bbbccc
cccaaa
cccbbb
cccccc多谢各位!!
from temp a,temp b
select 'aaa' as fname from dual
union all
select 'bbb' from dual
union all
select 'ccc' from dual
) a,
(
select 'aaa' as fname from dual
union all
select 'bbb' from dual
union all
select 'ccc' from dual
) bFNAME FNAME A.FNAME||B.FNAME
----- ----- ----------------
aaa aaa aaaaaa
aaa bbb aaabbb
aaa ccc aaaccc
bbb aaa bbbaaa
bbb bbb bbbbbb
bbb ccc bbbccc
ccc aaa cccaaa
ccc bbb cccbbb
ccc ccc cccccc
SELECT CONCAT(tt.id,tt.id1) FROM (SELECT a.id,b.id AS id1 FROM temp a,temp b )AS tt