Hi,

I have a view defined as:

CREATE OR ALTER VIEW V_USER_INFO(
ID,
TITLE,
NAME)
AS
SELECT
USERS.ID, COALESCE(CT_TITLES.DESCRIPTION, USERS.CT_TITLES_ID) AS TITLE, USERS.FULL_NAME AS NAME
FROM CT_TITLES
RIGHT OUTER JOIN USERS ON (CT_TITLES.ID = USERS.CT_TITLES_ID)


A typical result is:

ID TITLE NAME
1 Dr. Abraham Thomas
2 <null> Annelie Mans
3 Ms. Chameney Engelbrecht
4 <null> Colin Forbes


How do I change the view to display the result as?

ID FULLNAME
1 Dr. Abraham Thomas
2 Annelie Mans
3 Ms. Chameney Engelbrecht
4 Colin Forbes



Regards,

Nols Smit