Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 2 of 2 total |
database.table.field |
Sun, May 13 2007 1:51 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
What happens behind the scenes with a table alias? I ask because I know LEFT OUTER JOIN Information.IndexColumns ON Information.IndexColumns.ColumnName = TC.Name AND Information.IndexColumns.TableName = 'MandN' Doesn't work but LEFT OUTER JOIN Information.IndexColumns XC ON XC.ColumnName = TC.Name AND XC.TableName = 'MandN' Does I also found alias.fieldname can be used in the select statement but database.table.filedname can't. What I'm wondering is what happens if you have the same tablename in two databases and why an alias can be used but not the fully qualified bit. Puzzled of the Scottish Highlands |
Mon, May 14 2007 5:41 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< I also found alias.fieldname can be used in the select statement but database.table.filedname can't. What I'm wondering is what happens if you have the same tablename in two databases and why an alias can be used but not the fully qualified bit. >> If you have the same table name in two databases in the same query, then you'll need to assign one or both a correlation name in order to distinguish it from the other. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |