?主要看多個with的格式

[sql]?view plain?copy

?

1. WITH??
2. T3?AS??
3. (??
4. SELECT?T1.ID,?T1.CODE1,?T2.DESCRIPTION??
5. FROM?TB_DATA?T1,?TB_CODE?T2??
6. WHERE?T1.CODE1?=?T2.CODE??
7. ),??
8. T4?AS??
9. (??
10. SELECT?T1.ID,?T1.CODE2,?T2.DESCRIPTION??
11. FROM?TB_DATA?T1,?TB_CODE?T2??
12. WHERE?T1.CODE2?=?T2.CODE??
13. )??
14. SELECT?T3.ID,?T3.DESCRIPTION,?T4.DESCRIPTION??
15. FROM?T3,?T4??
16. WHERE?T3.ID?=?T4.ID??
17. ORDER?BY?ID;??