Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ricom19
Starting Member
4 Posts |
 Posted - 2007-06-16 : 08:37:24
|
| hello guys,i want to provide an SQL query to set all the priority to 1 for all customers that have all their orders being for a product with importance of 100. Thank you in advance. Shcema----------------------------------------------------------------There are three tables in the database: Customer, Product and Orders.The Customer table has three column: Customer_id (PK), priority, Address. The Orders table has three colums as well: Order_id (PK), Customer_id (FK), Product_id (FK)The Product table has three columns as well: Product_id(PK), Product_name, Importance.So the order table is connected to both the product and the customers table by respective foreign key. |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
|
|
ricom19
Starting Member
4 Posts |
Posted - 2007-06-16 : 08:53:11
|
| i am sorry....it won't happen again. |
 |
|
|
|
|
|
(newbie) Please May i get some help with Updates