Jan, what you need to do is to define the names. You are probably defining your view along the lines of
CREATE VIEW <viewname> AS +
SELECT <collist> FROM <tablelist> WHERE <conditions>
You need to do it like this:
CREATE VIEW <viewname> (<collist>) AS +
SELECT <collist> FROM <tablelist> WHERE <conditions>
By putting in the list of names to appear in the view, the view looks more like a table.
Jan Johansen <[EMAIL PROTECTED]> wrote:
When you create a view you get columns like
t10.company
t5.serial
t16.make
Do you need to include the table numbers in a choose statement or are the
column names sufficient?
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]
