ÇóÒ»¸ösqlÎĵÄд·¨

Ò»Õűítable×Ö¶ÎF1ºÍF2

F1    F2
1    a                               
2    b                               
3

´ï³ÉµÄЧ¹û£º

1  a
1  b
2  a
2  b
3  a
3  b

ÇóÕâ¸ösqlÎÄ Ó¦¸ÃÔõÑùд£¿Ð¡µÜ³õѧ£¬Âé·³¸÷λ´óÏÀÖ¸½Ì¡£

---

select a.F1,b.F2
from table a, table b
where b.dummy2 is not null
order by a.F1,b.F2
¿´¿´Õâ¸öÐÐÂð£¿
²»ÖªµÀÄãÓÃÀ´×öʲôµÄ£¿

---

SELECT * from
£¨SELECT F1 from TABLE£©
CROSS JOIN
£¨SELECT F2 from TABLE£©

---

һ¥¿ÉÐÐ.

SELECT TA.F1,TB.F2 from TABLE TA, TABLE TB WHERE TB.F2 IS NOT NULL ORDER BY TA.F1,TB.F2

¶þÂ¥µÄûÓйýÂËnull¡£

---

try it
SQL code:
SELECT b.f1, a.f2
from my_test a, my_test b
WHERE a.f2 IS NOT NULL;

---

SQL code:
create table t(F1 number,F2 varchar2(10));
insert into t values(1,'a');
insert into t values(2,'b');
insert into t values(3,'');
comm