My 'Union Query is throwing Unknown Command 1

[VijiKumara]

Select  Distinct L.NM_LINE, D.nm_fac, S.TRANSFORMER_OPER_ID, S.FEEDER_NUMBER, S.INDUSTRIAL, S.COMMERCIAL, S.RESIDENTIAL, S.TOTAL
 from 
          amp.tb_line L,  
          amp.tb_sect K,  
          amp.site D,
          amp.trits.feeder_customer S
where K.cd_stat = 'C' and l.cd_stat = 'C'
         and K.ik_line = L.ik_line  
          and D.ik_site = K.ik_site_end 
           and  D.nm_fac = S.SUBSTATION_NAME
UNION
select  Distinct L.NM_LINE, D.nm_fac, S.TRANSFORMER_OPER_ID, S.FEEDER_NUMBER, S.INDUSTRIAL, S.COMMERCIAL, S.RESIDENTIAL, S.TOTAL
from 
          amp.tb_line L,  
          amp.tb_sect K,  
          amp.site D,
          amp.trits.feeder_customer S
where K.cd_stat = 'C' and l.cd_stat = 'C'
         and K.ik_line = L.ik_line  
          and D.ik_site = K.ik_site_beg;
            and  D.nm_fac = S.SUBSTATION_NAME;

Following is the result i am getting(Please refer to the image attachment)

 

[VijiKumara]

This is in Oracle SQL Developer

 

[SkipVought]

Hi,

Do each of the Select queries run to completion independently?

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[MakeItSo]

Remove the semicolon in the second but last line "and D.ik_site = K.ik_site_beg;" perhaps?

"Knowledge is power. Information is liberating. Education is the premise of progress, in every society, in every family." (Kofi Annan)
Oppose SOPA, PIPA, ACTA; measures to curb freedom of information under whatever name whatsoever.

 

[VijiKumara]

Thank you much, folks. I executed both the queries separately and also I removed the extra semicolon I added. It worked. You guys are simply awesome.