Code: Alles auswählen.
SELECT A_PRGEWICH
*
* FROM Y000000P AS U
* JOIN Y000002S AS V
* ON U~N0_FALLNR = V~N0_FALLNR AND
* U~N0_PATNAME = V~N0_PATNAME AND
* U~N0_ALTEINH = V~N0_ALTEINH
*
* INTO (Gewicht)
*
* WHERE U~N0_FALLNR = V~N0_FALLNR AND
* U~N0_PATNAME = V~N0_PATNAME AND
* U~N0_ALTEINH = V~N0_ALTEINH.
* UPDATE Y000002S
*SET R_RDGEWICH = Gewicht
*WHERE N0_FALLNR = '2005000132'.