SQL Problem

Code: Alles auswählen.

SELECT * from Y000000O INTO CORRESPONDING FIELDS OF TABLE TU_Y000000O
  WHERE  ( N0_fallnr = '2007000125'
   AND N0_DIAGSCH = 'C34' )
   OR N0_DIAGSCH = 'C34.0'
   OR N0_DIAGSCH = 'C34.1'
   OR N0_DIAGSCH = 'C34.2'
   OR N0_DIAGSCH = 'C34.3'
   OR N0_DIAGSCH = 'C34.8'
   OR N0_DIAGSCH = 'C34.9'.

Code: Alles auswählen.

SELECT * from Y000000O INTO CORRESPONDING FIELDS OF TABLE TU_Y000000O
  WHERE  N0_fallnr = '2007000125'
   AND 
   (  N0_DIAGSCH = 'C34' 
   OR N0_DIAGSCH = 'C34.0'
   OR N0_DIAGSCH = 'C34.1'
   OR N0_DIAGSCH = 'C34.2'
   OR N0_DIAGSCH = 'C34.3'
   OR N0_DIAGSCH = 'C34.8'
   OR N0_DIAGSCH = 'C34.9'). 

Code: Alles auswählen.

SELECT * from Y000000O INTO CORRESPONDING FIELDS OF TABLE TU_Y000000O
  WHERE  N0_fallnr = '2007000125'
   AND 
     N0_DIAGSCH IN ('C34', "ACHTUNG kein Leerzeichen nach der Klammer
                    'C34.0',
                    'C34.1',
                    'C34.2',
                    'C34.3',
                    'C34.8',
                    'C34.9' ). "ACHTUNG kein Leerzeichen vor der Klammer