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 >