Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 7 of 7 total |
Heterogenous joins |
Sat, Apr 19 2008 11:20 AM | Permanent Link |
Jan-Erik | Hi,
I've been looking at ElevateDB for a ASP.NET project I'm about to start. I can't seem to find anything on heterogenous joins. Is it supported? Jan-Erik |
Mon, Apr 21 2008 9:22 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Jan,
<< I've been looking at ElevateDB for a ASP.NET project I'm about to start. I can't seem to find anything on heterogenous joins. Is it supported? >> ElevateDB only supports access to ElevateDB databases, so no, it doesn't support heterogeneous joins. What database(s) are you trying to access besides ElevateDB ? -- Tim Young Elevate Software www.elevatesoft.com |
Mon, Apr 21 2008 10:58 AM | Permanent Link |
Jan-Erik | "Tim Young [Elevate Software]" wrote:
Jan, << I've been looking at ElevateDB for a ASP.NET project I'm about to start. I can't seem to find anything on heterogenous joins. Is it supported? >> ElevateDB only supports access to ElevateDB databases, so no, it doesn't support heterogeneous joins. What database(s) are you trying to access besides ElevateDB ? -- What I was looking for was "heterogeneous joins" within ElevateDB, as in joining data from several ElevateDB Databases on the same server. e.g. select Database1.Table1 fields... union ALL select Database2.Table1 fields... Jan-Erik |
Tue, Apr 22 2008 12:03 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Jan-Erik,
<< What I was looking for was "heterogeneous joins" within ElevateDB, as in joining data from several ElevateDB Databases on the same server. >> Yes, you can do so, but only from within SQL statements or scripts that aren't stored in a database catalog, like in the form of a view or stored procedure/function. You can find out information on how to qualify such references here in the manual: http://www.elevatesoft.com/manual?action=mantopic&id=edb1sql&category=0&topic=6 -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Apr 22 2008 5:04 AM | Permanent Link |
Jan-Erik | "Tim Young [Elevate Software]" wrote:
<< Jan-Erik, << What I was looking for was "heterogeneous joins" within ElevateDB, as in joining data from several ElevateDB Databases on the same server. >> Yes, you can do so, but only from within SQL statements or scripts that aren't stored in a database catalog, like in the form of a view or stored procedure/function. You can find out information on how to qualify such references here in the manual: http://www.elevatesoft.com/manual?action=mantopic&id=edb1sql&category=0&topic=6 >> OK, that's what I was looking for. Thanks! Jan-Erik |
Thu, Feb 4 2010 5:24 PM | Permanent Link |
Josh Petitt | Greetings Tim,
Can you please elaborate on this? For example, I am trying to do a join between a table that exists in the database and a Memory table. I cannot figure out the syntax to do this. BTW, I am trying to do this with a RemoteDatabase. TIA |
Mon, Feb 8 2010 10:07 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Josh,
<< Can you please elaborate on this? For example, I am trying to do a join between a table that exists in the database and a Memory table. I cannot figure out the syntax to do this. BTW, I am trying to do this with a RemoteDatabase. >> You would just preface the name of each table with the database name: SELECT * FROM MyDatabase.MyTable INNER JOIN MyMemoryDatabase.MyOtherTable ON... -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Saturday, April 27, 2024 at 08:52 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |