CREATE OR REPLACE VIEW op_customers (realid,virtualid) as SELECT DISTINCT users.login as realid, COALESCE(op_static.virtualid,CRC32(users.login)) as virtualid FROM users LEFT JOIN op_static on op_static.realid=users.login LEFT JOIN op_denied ON users.login = op_denied.login WHERE op_denied.login IS NULL;