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 ...
Aside from explicitly listing all columns, is there an easy way to
accomplish this view?