> 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

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.