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...
You can do in ABAP Very well using Joins...
INTO TABLE itab
FROM kna1 AS a
INNER JOIN knvk AS b
ON akunnr = bkunnr.
By using joins we can select feilds from 2 different tables, criteria is the tables must have a common key amontg them.