Oracle with语句示例

来源:互联网 发布:上海徐家汇老姚 知乎 编辑:程序博客网 时间:2024/05/22 05:12
 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