Re: using MAX function...

Sorry, forgot about the view!

CREATE OR REPLACE VIEW view_name AS
SELECT MAX(user_id) MAXUSER,first_name,last_name FROM table_name
GROUP BY user_id,first_name,last_name;

you need a column alias for the expression Received on Wed Mar 08 2000 - 15:17:57 CST