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