This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: From customer table, order table, product table Where promotion code = “hockey” and customer.customerID = order.customerID and order.productID = product.productID Select fname, lname, shipping address, From customer table, order table Where ship date =#02/14/10# and customer.customerID = order.customerID Order by lname Proflowers Online Databases...
View Full Document
- Spring '08
- Relational model, Proflowers.com Online Process, count customer ID