Martijn Tonies wrote:
When creating the view, use CREATE VIEW viewname ( column names ) AS select [fields]Instead of "*". This way, you can only return a single "mat" column instead of having that column twice in the view.
i'll try that programmatically, no way am i typing close to 1000 field names into the query browser ;-)
thanks les schaffer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]