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 |
|
sqlclarify
Yak Posting Veteran
56 Posts |
 Posted - 2009-05-11 : 02:00:53
|
| Could somebody explain what a base table is and how we would select what to use as a base table? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-11 : 10:56:06
|
| base table is table from which you build a view. a view is a virtual table which takes its data from one or more tables. All of source tables used by view are called its base tables. |
 |
|
|
sqlclarify
Yak Posting Veteran
56 Posts |
Posted - 2009-05-13 : 20:14:41
|
| Is there a way to decide which table you should use as the first table after FROM?That is select * from table Ajoin table B.. etc. etc.Would it make a difference if you use all "joins" in your query? |
|
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2009-05-13 : 20:51:10
|
| In this case you are doing an inner join , so it shouldn't matter. But if you are using a LEFT or a RIGHT join, the table you use first makes a difference. Read about JOINs to get a clear idea. |
|
|
|
|
|
|
base table