急！！ORACLE 随机组合

Question

表
ID PID NAME
1 0 A
2 0 B
3 1 A1
4 1 A2
5 2 B1
6 2 B2

希望得到的结果

NAME1 NAME2
A1 B1
A1 B2
A2 B1
A2 B@

求大神帮忙 谢谢！！！

Answer 1

select t1.name name1,t2.name name2 from A t1 ,A t2
where t1.pid = 1 and t2.pid = 2;