topic Re: Inner join in Application Development and Automation Discussions

Inner join

Former Member — Tue, 04 Dec 2007 11:24:50 GMT

can anybody tell is the following code works properly.

select-options: datum for afvv-fsavd.

select afvc_{arbid afvc}steus afvv_{aufpl afvv}aplzl afvv_{dauno afvv}fsavd into corresponding fields of table i_afvc_afvv from afvc inner join afvv on afvc_{aufpl = afvv}aufpl and afvc_{aplzl = afvv}aplzl where afvv~fsavd in datum and

afvc~steus = 'PP01' or

afvc~steus = 'ZP05'.

Regards,

Naseer.

Re: Inner join

Former Member — Tue, 04 Dec 2007 11:27:38 GMT

( afvc~steus = 'PP01' or

afvc~steus = 'ZP05' ).

its ok,

Re: Inner join

Former Member — Tue, 04 Dec 2007 11:29:29 GMT

Hi,

Its correct.

Regards,

Vani

Re: Inner join

Former Member — Tue, 04 Dec 2007 11:34:03 GMT

Hi,

do like this.

select-options: datum for afvv-fsavd.

select afvc_{arbid afvc}steus afvv_{aufpl afvv}aplzl afvv~dauno

afvv~fsavd into corresponding fields of table i_afvc_afvv

from afvc inner join afvv on afvc_{aufpl = afvv}aufpl and

afvc_{aplzl = afvv}aplzl where afvv~fsavd in datum and

( afvc_{steus = 'PP01' or afvc}steus = 'ZP05' ).

rgds,

bharat.