> >When creating the view, use
> >CREATE VIEW viewname ( column names )
> >AS
> >select [fields]
> >
> >Instead of "*". This way, you can only return a single "mat" column
instead
> >of having that column twice in the view.
> >
>
>
> i'll try that programmatically, no way am i typing close to 100
Martijn Tonies wrote:
When creating the view, use
CREATE VIEW viewname ( column names )
AS
select [fields]
Instead of "*". This way, you can only return a single "mat" column instead
of having that column twice in the view.
i'll try that programmatically, no way am i typing close to 1000 fi
Les,
> i am working on a database system where a number of tables (5-10) each
> with possibly hundreds of columns share an identical primary key name.
> the truth is if it weren't for a limitation in the number of columns in
> M$ Access (long story: we're creating a client server scheme so th
i am working on a database system where a number of tables (5-10) each
with possibly hundreds of columns share an identical primary key name.
the truth is if it weren't for a limitation in the number of columns in
M$ Access (long story: we're creating a client server scheme so they
can get
