|
-
Sql Query
hi!!!
i hv prob in a query.......
the tables r
cust(cust_id(PK),fname,lname,area,phone_no)
invoice(inv_no,mv_no(FK),cust_id(FK),issue_date,re turn_date)
movie(mv_no(PK),title,type,star,price)
the query is
List the movie no. and name issue to all customers.
tht is the query should return those mv_no which r issued to all d customers in cust table.
can anyone help???
thanx......
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|