SQL statement help# Database - 数据库
a*o
1 楼
Hello, all
I got the following SQL statement problems. Does anybody can give me a hand.
Thanks a lot.
Three tables:
Customers (Cid, Cname, Ctele, Caddr)
Items (Item#, Iname, Qty_On_Hand, Price)
Purchases (Cid, Item#, Qty)
Problem is list all Cname's for all customers who are either located in
"Boston" or they purchase Iname = "Coats". Indicate by an additional column in
your output whether the Customer is located in "Boston" or has Purchase
"Coats".
Thanks in advance.
I got the following SQL statement problems. Does anybody can give me a hand.
Thanks a lot.
Three tables:
Customers (Cid, Cname, Ctele, Caddr)
Items (Item#, Iname, Qty_On_Hand, Price)
Purchases (Cid, Item#, Qty)
Problem is list all Cname's for all customers who are either located in
"Boston" or they purchase Iname = "Coats". Indicate by an additional column in
your output whether the Customer is located in "Boston" or has Purchase
"Coats".
Thanks in advance.