selecting fields from 2 different tables with single select query..

[Former Member]

hi...

can we select fields from two different tables in a single select query... under some where condition for both the tables...

the same thing can be done in sql what about in abap...

thanks...

[Former Member]

hi...

can we select fields from two different tables in a single select query... under some where condition for both the tables...

the same thing can be done in sql what about in abap...

thanks...

[Former Member]

Yes,

By using joins we can select feilds from 2 different tables, criteria is the tables must have a common key amontg them.

Regards,

Raghav

[abdul_hakim]

Hi Naveen,

You can do in ABAP Very well using Joins...

eg.

SELECT a~kunnr

a~name1

b~pernr

INTO TABLE itab

FROM kna1 AS a

INNER JOIN knvk AS b

ON a_{kunnr = b}kunnr.