[thelist] MS SQL Syntax Help

[rudy]

> I don't see why that syntax should work anywhere
> since a select returns a recordset, not a table.

hi judah

a recordset *is* a table

the nested select in the FROM clause is standard sql (sql-92)

whether it works or not in microsoft sql/server is a separate question

> I had a similar problem where I wanted to create a full-text index on
> a view, but I couldn't because a view is a recordset not a table.

actually, a view is only a definition (except if it's a "materialized"
view, a new feature in sql/server)

it makes sense that you cannot declare an index on a view


rudy