19
3.
相關的
SQL
語法
(9/10)
Joint
運算(
2
)
如要找出所有的曾經購買過的會員,並列出
其購買的產品名稱
SQL
:
Select c.c_Name, p.p_Name
From Customer as c, Order as o, Product as p
Where o.pId=p.pId and c.mId=o.Mid
XML
:
FOR $c IN document(
“
customer1.xml
”
)//c_record
RETURN
<customer1>
$c/c_Name
FOR $o IN document(
“
order.xml
”
)// order_record [mId = $o/mId]
$p IN document(
“
product.xml
”
)//product_record [pId = $o/pId]
RETURN $p/p_Name
</customer1 >