From: Martijn Tonies
Date: November 19 2005 3:43pm
Subject: Re: Creating a view from a join
List-Archive: http://lists.mysql.com/mysql/191890
Message-Id: <000701c5ed1f$f6c32380$c802a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit




> I have two tables with quite a few fields and I want to create a view
> into a limited join of the table.  I have a query like:
>
>    select * from person
>       inner join student on person.id=student.id
>       where person.dormant != 'Y';
>
> The select works fine but when I try to use MySQL Query Browser to
> create a view from that query, it says that there's a duplicate column,
> id.  Is there a way that I can say something like:
>
>    select * except student.id from ...

Yes, but you do it like this:

select person.id, person.othercolumn, student.othercolumn etc etc...
from ...

> Aside from explicitly listing all columns, is there an easy way to
> accomplish this view?

No.

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com