SQL Problem

[bettina_martin]

Hi,

probiers mal mit "fetch first row only" wenn es wirklich egal ist ob du den ersten oder letzten DS bekommst!

 
CREATE VIEW cmsms1/zkna2_view AS ( 
select MANDT, KUNNR, NAME1, NAME2, STRAS, ORT01, PSTLZ, LAND1, 
SORTL, VALUE(TEL1, '') AS TEL1, 
VALUE(TEL2, '') AS TEL2, 
VALUE(MOBIL1, '') AS MOBIL1, 
VALUE(MOBIL2, '') AS MOBIL2, 
VALUE(EMAIL1,'') AS EMAIL1, 
VALUE(EMAIL2,'') AS EMAIL2, STCEG FROM ( 
SELECT A.kunnr, A.NAME1, 
(SELECT tel_number FROM r3p02data/adr2 
WHERE addrnumber=A.adrnr and consnumber='001' fetch first row only) AS TEL1, 
(SELECT tel_number FROM r3p02data/adr2 
WHERE addrnumber=A.adrnr and consnumber='002' fetch first row only) AS TEL2, 
(SELECT tel_number FROM r3p02data/adr2 
WHERE addrnumber=A.adrnr and consnumber='003' fetch first row only) AS MOBIL1, 
(SELECT tel_number FROM r3p02data/adr2 
WHERE addrnumber=A.adrnr and consnumber='004' fetch first row only) AS MOBIL2, 
(SELECT smtp_addr FROM r3p02data/adr6 
WHERE addrnumber=A.adrnr and consnumber='001' fetch first row only) AS EMAIL1, 
(SELECT smtp_addr FROM r3p02data/adr6 
WHERE addrnumber=A.adrnr and consnumber='002' fetch first row only) AS EMAIL2 
FROM r3p02data/kna1 a ) as A where kunnr<>'0000062871' )

habe das jetzt genau SO übernommen, jedoch bekomme ich folgenden Fehler:

Schlüsselwort FETCH nicht erwartet. Gültige Token: ) UNION EXCEPT