Skip to Content
0
K C
Sep 18, 2007 at 03:02 PM

Inner join to For all entries convert

177 Views

Plz tell me how to convert this code from <b>Inner join</b> to <b>For all entries</b>

<b>select afruaplzl afruarbid afruaufnr afruaufpl afru~budat

crhdarbpl crhdobjid crhdobjty crhdverwe

zvafvc_vuaplzl zvafvc_vuaufpl zvafvc_vu~ktsch

aufk~auart

into table int_hrs

from ( afru

inner join crhd

on

crhdobjid = afruarbid and

crhdwerks = afruwerks

inner join zvafvc_vu

on zvafvc_vuaufpl = afruaufpl and

zvafvc_vuaplzl = afruaplzl

inner join aufk

on aufkaufnr = afruaufnr

inner join afko

where

afru~werks in s_werks and

crhd~objty in s_objty and

crhd~verwe in s_verwe.</b>