Sql Query help..!!!

komal

Guppy
hiii!!!

i hv problem in a query..

the tables r
-------------------------
cust(cust_id(PK),fname,lname,area,phone_no)
movie(mv_no(PK),title,type,star,price)
invoice(inv_no(PK),mv_no(FK),cust_id(FK),issue_date,return_date)

the query is

List the movie no. and title issued to all customers

tht is the query should return mv_no which is issued to all customers in table cust..

pls help!!!
thanx.........
 
Back
Top