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

Log in
Name

Password

 
 

History for Question3

??changed:
-
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.