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 |
|
sapator
Constraint Violating Yak Guru
462 Posts |
 Posted - 2014-11-12 : 09:35:12
|
Hi.Show this: SELECT "ZZ_rptCCTransactions_Detail"."TransC_lgnNumber", "ZZ_rptCCTransactions_Detail"."PayLog_dtmTransDateTime" FROM "HO"."dbo"."rptCCTransactions" "rptCCTransactions" What is the meaning of the double table declaration?This comes from a crystal reports file that i am fiddling with. |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-11-12 : 10:07:51
|
| it's not a double declaration. the second occurrence of "rptCCTransactions" is a table alias.ref: http://technet.microsoft.com/en-us/library/ms187455(v=sql.105).aspx |
 |
|
|
sapator
Constraint Violating Yak Guru
462 Posts |
Posted - 2014-11-12 : 18:41:25
|
| Hi, i thought of that but if i change the alias in something other tha the exact name i get an error so i thought that it's not actually an alias. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-11-12 : 18:47:02
|
quote:
Originally posted by sapator
Hi, i thought of that but if i change the alias in something other tha the exact name i get an error so i thought that it's not actually an alias.
Show us the error then. And also show us the actual query.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
a query with double table declaration?