Jan, a view is not a super select. Rather, it is a saved select that you can reuse ad infinitum. Some of the people on this list DO write super selects (Check out David Blocker), but virtually all the people on this list use views.
Some of us write all the view definitions for the database in a command file. It can be run to recreate the views whenever needed. DROP VIEW ViewName CREATE VIEW ViewName (Col1, Col2, Col3) AS + SELECT t1.Col1, t2.Col2, t1.Cole + FROM table_1 t1, table_2 t2 + WHERE t1.PK = t2.PK + AND whatever else you want to use. --- Jan Johansen <[EMAIL PROTECTED]> wrote: > I'm pretty sure that I read this on this forum but can't locate. > > If I understand correctly a view is kind of a super select. If I look at the > definition fo a > view it starts with SELECT so > I'm kind of right. > > But the syntax must not be quite the same. If I go to the view designer and > copy the definition > to the R: prompt; > I get various error messages. > > This is really for my own education but how would I translate a view into a > command? > > Jan > ===== Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED]
