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 |
|
im1dermike
Posting Yak Master
222 Posts |
 Posted - 2008-07-10 : 09:11:59
|
| I have a general question about creating views interactively. Let's say you have 3 different views you're inner joining on CUSTOMER_ID: CUSTOMER, VEHICLE, and PART. The hierarchy of these views is in the same order that I just stated. There is a table of all the customers, then a table of vehicles owned by each customer, and then a table of parts for each customer's vehicle.When you're interactively linking the tables together, do you have to link them by CUSTOMER_ID in the correct, hierarchical order or can you link them in any order? For example, CUSTOMER > PART > VEHICLE.Thanks |
|
|
MakeYourDaddyProud
184 Posts |
Posted - 2008-07-10 : 10:17:32
|
| So long and the join field is the same entity then yes, order does not matter.Make sure that any optional entities are casted with a left join which is like saying "give me all the rows but only list the joined rows if they exist".Dan>>>>> THE Whammy Bar String Trasher <<<<< |
 |
|
|
|
|
|
General question about creating views T-SQL