Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 7 of 7 total

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