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 |
|
ddog6785
Starting Member
2 Posts |
Posted - 2010-04-21 : 23:10:17
|
| I have two questions left for an assignment and I can not figure them out.Here they are:List the territory_id and the territory_name of all territories where end tables have been sold.List the total sales for each sales territory by salesperson.Any advise would be greatly appreciated.Thanks!I dont even know how to start these...I have completed the rest of my assignment...The problem with the first one is there is not a territory_id or territory_name under the order table so Im supposed to use a bunch of different tables...# customer_t# order_line_t# Order_t# product_t# territory_t# does_business_in_tI believe I am supposed to look at the order_line_t table then see if there is any end tables sold...but my problem comes when There is no territory_id in order_line_t or Order_t...Its only in does_business_in_t or territory_t. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2010-04-21 : 23:15:36
|
Have you give it a try at all ?Give it a try and post your query here and more specific question if you have issue. KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-21 : 23:16:43
|
| whats end table? probably you could give some sample data from tables and explain what you want. also give your tried query------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-21 : 23:48:49
|
| sorry still relationships not clear. post some data from them and explain------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|