You are not logged in Log in Join
You are here: Home » Members » MJ's corner on Zope » QuantumPythons » Question3 » wikipage_view
Log in
Name

Password

 
Link icon Forgot your password?
 
Print
FrontPage »

Question3

Question 3

Get pid values of products that are ordered by all customers who live in Dallas.

SQL: 

    select distinct pid 
        from ord_order_line, customer
                where customer.cid=ord_order_line.cid
                  and customer.city = 'Dallas' ;

Output: 

    PID
    ---
    p03
    p05

    2 record(s) selected.

Copyright (c) 2011 Zope Foundation. All rights reserved. Legal | Contact
If you can read this text, it means you are not experiencing the Plone design at its best. Plone makes heavy use of CSS, which means it is accessible to any internet browser, but the design needs a standards-compliant browser to look like we intended it. Just so you know ;)