I am very proud of myself for figuring out how to write a query where I have 3 Aliases of 1 table and 2 Aliases of another table. It works. It based on 200+ columns table and my question is how safe it is to have such a query for the Report? I am planing to write it into SQL Server view. Am I up for a trouble? What should I consider doing stuff like I just did? Thanks
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
3Aliases + 2Aliases (NOT urgent)
- Thread starter NewToCR
- Start date
In SQL, you can accumulate in a work-table, from several tables or from the same table several times, and moving from one work-table to another. Start off with something like
and define it yourself.
It's also worth joining the SQL forum on Tek Tips.
![[yinyang]](/data/assets/smilies/yinyang.gif "[yinyang] [yinyang]")
Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10
Code:
create table #MW_WAIt's also worth joining the SQL forum on Tek Tips.
Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 - Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question