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 = '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