Inner join

[Former Member]

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.

[Former Member]

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

its ok,

[Former Member]

Hi,

Its correct.

Regards,

Vani

[Former Member]

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.