List:General Discussion« Previous MessageNext Message »
From:Les Schaffer Date:July 1 2005 2:32pm
Subject:Re: View onto tables w/ identical key names
View as plain text  
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 field 
names into the query browser   ;-)

thanks

les schaffer


Thread
View onto tables w/ identical key namesLes Schaffer30 Jun
  • Re: View onto tables w/ identical key namesMartijn Tonies1 Jul
    • Re: View onto tables w/ identical key namesLes Schaffer1 Jul
  • Re: View onto tables w/ identical key namesMartijn Tonies1 Jul