select ws.server_id, ws.neat_name, ws.host_addr, ws.smtp_addr, ws.smtp_auth_p, ws.imap_port, ws.active_p, ws.imap_addr, ws.smtp_port, (select type from webmail_serv_types where ws.server_type = type_id) as server_type from webmail_servers ws order by ws.neat_name update webmail_servers set active_p = :active_p where server_id = :server_id delete from webmail_servers where server_id = :server_id update webmail_servers set smtp_auth_p = :smtp_auth_p where server_id = :server_id