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 |
|
spthomas
Starting Member
14 Posts |
 Posted - 2011-09-23 : 18:47:24
|
| I am trying to find the tables specified in a bunch of stored procs. I have a join clause like this:left join db1..OrderHeader zdgOrderHeader on Table2.COLUMN1 = zdgOrderHeader.OrderIdetc.WHAT is zdgOrderHeader? There is no AS clause or anything. Is that an alias for OrderHeader or another table altogether? |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2011-09-23 : 20:08:15
|
| prbly an alias.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-24 : 04:53:16
|
| its an alias. AS is optional why specifying alias------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
extra table name in Join?