Re: MSSQL 7.0 overview ...

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