Text 형의 컬럼이 있어서 UNION을 사용할 수 없네요
컬럼 데이터 타입을 안바꾸려니 사이베이스에서는 TEXT 데이터 타입에서는 UNION 이 허용이 안되는군요
UNION을 사용하지 않고 같은 결과를 얻으려면 어떻게 수정해야 하는지요?

        SELECT
                USERS_ID,
                USERS_PASSWD,
                DATE_FORMAT(USERS_ABSENT_SDATE, '%Y-%c-%e %T') USERS_ABSENT_SDATE,
                DATE_FORMAT(USERS_ABSENT_EDATE, '%Y-%c-%e %T') USERS_ABSENT_EDATE,
        FROM
                USERS
        WHERE
                USERS_IDX = ?
        UNION
        SELECT
                A.USERS_ID,
                A.USERS_PASSWD,
                DATE_FORMAT(A.USERS_ABSENT_SDATE, '%Y-%c-%e %T') USERS_ABSENT_SDATE,
                DATE_FORMAT(A.USERS_ABSENT_EDATE, '%Y-%c-%e %T') USERS_ABSENT_EDATE
                FROM
                USERS A,
                ACCOUNT B
        WHERE
                B.ACCOUNT_IDX = ?
                AND
                B.USERS_IDX = A.USERS_IDX
                AND
                B.ACCOUNT_ISVALID = 1
                AND
                (
                        B.ACCOUNT_ISDATED = 0
                        OR
                        (
                                B.ACCOUNT_ISDATED = 1
                                AND
                                ACCOUNT_SDATE <= NOW()
                                AND
                                ACCOUNT_EDATE >= NOW()
                        )
                )