Re: MSSQL 7.0 overview ...

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