datatype

From: Christopher <chris.lo_at_cyberwisdom.net>
Date: Fri, 12 Jan 2001 21:12:26 +0800
Message-ID: <93mvmm$h3q$1@horn.hk.diyixian.com>

I got "ORA-01790: expression must have same datatype as corresponding expression"
when executing the following SQL statment :

select A.gpm_ent_id_group A_id

,NULL B_id

            from GroupMember A
            where A.gpm_ent_id_member = 6

 UNION
 select A.gpm_ent_id_group A_id

,B.gpm_ent_id_group B_id

             from GroupMember A, GroupMember B
            where A.gpm_ent_id_member = 6
             and A.gpm_ent_id_group  = B.gpm_ent_id_member ;

p.s. Both gpm_ent_id_member and gpm_ent_id_group are NUMBER(38)

So I modify the SQL to :

select A.gpm_ent_id_group A_id

,to_number(NULL) B_id

            from GroupMember A
            where A.gpm_ent_id_member = 6

 UNION
 select A.gpm_ent_id_group A_id

,B.gpm_ent_id_group B_id

             from GroupMember A, GroupMember B
            where A.gpm_ent_id_member = 6
             and A.gpm_ent_id_group  = B.gpm_ent_id_member ;

However, it is not an ANSI SQL. Is there any ANSI solution for this situation?

Thanks. Received on Fri Jan 12 2001 - 07:12:26 CST