Thread: Subquery in the FROM clause in microsoft.public.sqlserver.programming

  On Nov 3, 9:48?pm, "David Portas" <REMOVE_BEFORE_REPLYING_dpor...@acm.org> wrote: > A query used in the FROM clause is called a "derived table subquery" because > it returns some rows of data exactly as if that data existed in a table. > So essentially data returned from subquery ( inside FROM clause ) acts as a table? Also, as far as I can tell we can’t have...

   

  Well, here is the SyBase position on your question. It is not ANSI standard and you can get what you want another way. http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15.0.sqlug/html/sqlug/sqlug413.htm FWIW, RLF "klem s" <sqlsurfring@gmail.com> wrote in message news:218412ee-d8e2-475e-a601-0a040d293bc3@s15g2000yqs.googlegroups.com... On Nov 3, 9:48 pm, "David...

  On Wed, 4 Nov 2009 12:03:04 -0800 (PST), klem s wrote: >On Nov 3, 9:48?pm, "David Portas" ><REMOVE_BEFORE_REPLYING_dpor...@acm.org> wrote: >> A query used in the FROM clause is called a "derived table subquery" because >> it returns some rows of data exactly as if that data existed in a table. > >So essentially data returned...

  klem s wrote: > So essentially data returned from subquery ( inside FROM clause ) acts > as a table? > Yes, this is why the derived table is called a table expression. > > Also, as far as I can tell we can’t have a correlated subquery inside > a FROM clause? Why is that? > On SQL Server 2005/2008 you can use the APPLY operator in the FROM clause which allows you to use a correlated...