using 2 tables

[Former Member]

i hv to use 3 fields ....but 2 fields r in table-1 and 3rd field is in table-2

so what would b the select query for this.................

[former_member156446]

select using Inner joins

SELECT d~aufnr d~qmnum a~aufpl a~pernr a~steus " flg_kmp
a~larnt a~anzzl a~preis a~waers
a~matkl a~ekgrp a~ekorg a~lifnr a~ltxa1 a~banfn a~bnfpo
b~arbeh b~daune b~dauno b~mgvrg b~meinh
c~packno c~sub_packno c~srvpos
a~sakto c~netwr a~vornr
c~menge c~meins d~auart
INTO TABLE lt_all
FROM viaufkst AS d INNER JOIN
afvc AS a ON
d~aufpl = a~aufpl
INNER JOIN afvv AS b
ON a~aufpl = b~aufpl AND
a~aplzl = b~aplzl
INNER JOIN esll AS c
ON c~packno EQ a~packno
FOR ALL ENTRIES IN lt_viau
WHERE d~aufnr = lt_viau-aufnr AND
d~aufpl = lt_viau-aufpl AND
d~auart = lt_viau-auart.

[Former Member]

SELECT t1_{field1 t2}field1 t1~field3

INTO TABLE itab

FROM t1

inner JOIN t2 ON t1_{<field> = t2}<field>.