Skip to Content
0
Former Member
Dec 24, 2007 at 10:22 AM

HELP WITH JOIN

15 Views

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%'.