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? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]