Re: MSSQL 7.0 overview ...

I think this is not related to the backend databases. This works like Access link tables which can be any kind of data sources. There should be other middleware that can support multiple data sources query other than OLEDB.

ªü¼Ö¥K (owenp_at_NO_geocities_SPAM.com) wrote:
: hm ... yes, but the point is MSSQL 7.0 can join with two(or more) different
: kind of datasources
: which is OLEDB or ODBC supported and SQL 7.0 itself.
: e.g. u can join two tables one from SQL 7.0 and one from ORACLE or even an
: Excel file.
:
: Thanks in advice
:
: Arnox,
: 8^)
:
:
: Ng K C Paul wrote:
:
: > It looks like Oracle's inline VIEW subquery
: >
: > SELECT *
: > FROM (SELECT ename FROM emp WHERE deptno = 10)
: > WHERE job = 'CLERK'
: >
: > ªü¼Ö¥K (owenp_at_NO_geocities_SPAM.com) wrote:
: > : Hi,
: > : after a MSSQL 7.0 overview course, they introduced a very useful query
: > : function.
: > : it can 'select' from 'OLEDB' or 'ODBC' supported data source within
: > : query.
: > : e.g. select a.col1, a.col2, b.col3, b.col4
: > : from ('OLESQL','dbname','sa','password',
: > : 'select col1, col2 from oletbl') as a, localtb as b
: > : where a.col1 = b.col1
: > :
: > : (not 100% correct syntax)
: > :
: > : it is not a offence, i just want to know does sybase (ASE 11.5 or 11.9)
: > : has a simular function ?
: > :
: > : Thanks in advice
: > :
: > : Arnox,
: > : 8^)
: > :
:
:
:
Received on Wed Nov 11 1998 - 00:00:00 CST