🚀 go-pugleaf

Yes - there is extra work! If I have a view joining A,B and C - and
I query against the view, only rows which match the original view
definition (and whatever further restriction I place in my query) are
returned. So it must do the join defined in the VIEW in order to
determine whether to show me the 'result':

CREATE VIEW x AS
SELECT a.q, b.r, c.s FROM a,b,c WHERE a.id = b.id and b.id2 = c.id2

SELECT q FROM x  (where column q originally comes from the a)

This must give me column q from the original table a - but only for
rows of a that have a corresponding row of b - which in turn have
a corresponding row in c. So the join to b and c must be done before
determining which rows to return.

Jim

==============================================================================
Jim Panttaja                                   Panttaja Consulting Group, Inc.
INTERNET:   jim@pcgi.com                   103 Plaza St., Healdsburg, CA 95448
uunet:      uunet!pcg!jim                                         707 433-2629
CompuServe: 74513,346                                         FAX 707 431-0549
==============================================================================