CREATE OR REPLACE VIEW KNOWN_USERS (
 CLIENT_ID, CORPORATE_ID, USER_TYPE, 
 USERID, PASSWORD, EMAIL_ADDRESS,
 ADDRESS_ID, TITLE, 
 FIRST_NAME, LAST_NAME,
 MIDDLE_INITIAL, CONTACT_METHOD, CONTACT_STATUS, 
 DISPLAY_PHONE, DISPLAY_FAX, DISPLAY_EMAIL, REPORT_FREQ, WANT_NEWS, WANT_ADS,
 FAX_NUM, PHONE_NUM, PHONE_NUM2, PHONE_NUM3, 
 RESTRICTED_IP_ADDRESS, CONFIG, NUM_PER_PAGE, MAX_DISTANCE)
AS 
SELECT exu.USERID, exu.F16, exu.F8,
  u.NICKNAME, u.PASSWORD, u.EMAIL, 
  exu.F4, exu.F20,
  exu.F1, exu.F3,
  exu.F2, exu.F9, exu.F19,
  'Y', 'Y', 'N', 'MONTHLY', 'Y', 'Y',
  exu.F11, exu.F10, exu.F12, exu.F13, 
  NULL, 'NORMAL', 50, 400
FROM USERS u, EXTENDED_USER exu
where u.USERID = exu.USERID;