Bonjour, est ce quelqu'un pourrait m'expliquer cette requête svp.
Merci
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11 refresh i_data. select t2~PERNR NACHN VORNA ORGEH CORPS GRADE PNALT FROM ( ( ( PA0002 as t2 inner join PA0001 as t1 ON t2~PERNR = t1~PERNR ) inner join PA0431 as t431 ON t2~PERNR = t431~PERNR ) inner join PA0032 as t32 ON t2~PERNR = t32~PERNR ) into corresponding fields of table i_data where t2~pernr in so_pernr and t1~ENDDA = '99991231' and t2~ENDDA = '99991231' and t32~ENDDA = '99991231' and t431~ENDDA = '99991231' and t431~SUBTY = '0'.
Partager