Entalyan

SELECT b.MemberCardNumber,
       b.MemberName,
       b.MemberSurname,
       COALESCE (b.MobilePhone, (SELECT i.MobilePhone FROM TerminalMemberTable i WHERE UPPER (i.MemberName) = UPPER (b.MemberName) AND UPPER (i.MemberSurname) = UPPER (b.MemberSurname) AND rownum <= 1 ORDER BY i.MobilePhone DESC NULLS LAST))    MobilePhone,
       COALESCE(b.HomePhone, (SELECT i.HomePhone FROM TerminalMemberTable i WHERE UPPER(i.MemberName) = UPPER(b.MemberName) AND UPPER(i.MemberSurname) = UPPER(b.MemberSurname) AND rownum <= 1 ORDER BY i.HomePhone DESC NULLS LAST))  HomePhone,
       COALESCE(b.EmailAddress, (SELECT i.EmailAddress FROM TerminalMemberTable i WHERE UPPER(i.MemberName) = UPPER(b.MemberName) AND UPPER(i.MemberSurname) = UPPER(b.MemberSurname) AND rownum <= 1 ORDER BY i.EmailAddress DESC NULLS LAST))    EmailAddress
FROM    (
        SELECT MemberCardNumber,
               MemberName,
               MemberSurname,

Entalyan

/* DROP STATEMENTS */
DROP TABLE USER_ROLES;
DROP TABLE USER_LOGINS;
DROP TABLE USER_CLAIMS;
DROP TABLE USERS;
DROP SEQUENCE USER_ROLES_SEQ;
DROP SEQUENCE USER_LOGINS_SEQ;
DROP SEQUENCE USER_CLAIMS_SEQ;
DROP SEQUENCE USERS_SEQ;

Entalyan

/* DROP STATEMENTS */
DROP TABLE USER_ROLES;
DROP TABLE USER_LOGINS;
DROP TABLE USER_CLAIMS;
DROP TABLE USERS;
DROP SEQUENCE USER_ROLES_SEQ;
DROP SEQUENCE USER_LOGINS_SEQ;
DROP SEQUENCE USER_CLAIMS_SEQ;
DROP SEQUENCE USERS_SEQ;

Entalyan

/* DROP STATEMENTS */
DROP TABLE USERS_USER_ROLES;
DROP TABLE USER_ROLES;
DROP TABLE USER_LOGINS;
DROP TABLE USER_CLAIMS;
DROP TABLE USERS;

/* USERS */
CREATE TABLE USERS
(

Entalyan

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data;
using Oracle.DataAccess.Client;

namespace CSharp_Console
{