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.........
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.........