HI,
i new with join and i have this code and i wont to separate it to 2 select
how i can do that ?
i reward
SELECT /bic/pybproject~/bic/ybproject
/bic/tybproject~txtmd
FROM /bic/pybproject
LEFT OUTER JOIN /bic/tybproject ON /bic/tybproject/bic/ybproject EQ /bic/pybproject/bic/ybproject
AND /bic/tybproject~langu EQ sy-langu
INTO CORRESPONDING FIELDS OF TABLE projects
WHERE /bic/pybproject~changed NE 'D'
AND /bic/pybproject~/bic/zps_pr_rs EQ /bic/zps_pr_rs
and /bic/pybproject~/BIC/ZPS_SY_ST not like 'CLSD%'.