From: paulkcng@news.netvigator.com (Ng K C Paul)
Subject: Re: MSSQL 7.0 overview ...
Date: 1998/11/11
Message-ID: <72b95p$q6r$1@imsp009a.netvigator.com>#1/1
References: <364913A0.F3AB8261@NO_geocities_SPAM.com>
Organization: Netvigator
Newsgroups: comp.databases.sybase,comp.databases.oracle.server,comp.databases.ms-sqlserver


It looks like Oracle's inline VIEW subquery

SELECT * 
FROM (SELECT ename FROM emp WHERE deptno = 10)
 	WHERE job = 'CLERK' 

ªü¼Ö¥K (owenp@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^)
: