Re: UPDATE question

On Fri, 08 May 98 17:17:10 GMT, gaverill_at_chsra.wisc.edu (Gerard M. Averill) wrote:

>My question is: why is T.B an invalid column name within the inline views but
>not in the subquery?

Because an inline view is a view not a subquery. In other words, you could not create a view like this:

	create view maxpx as
		select max(P.X) X
      	from P
           where P.X <= T.B

so you can't use it as an inline view either.

Jonathan Received on Fri May 08 1998 - 22:34:52 CDT