Oracle With 语法 示例
Oracle with语句示例
WITH a AS (SELECT * FROM bd_member WHERE ROWNUM<10),
b AS (SELECT * FROM tp_trade_card)
select A.MEMBER_NAME,
B.CARD_NO
from A,
B
where A.BD_MEMBER_ID = B.BD_MEMBER_ID
Google ...
2007-01-18 19:11:35 ·
297 阅读 ·
0 评论