Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

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

Go to solution
Former Member

‎2005 Nov 30 7:56 AM

0 Likes
3,808

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

1 ACCEPTED SOLUTION
Read only

Go to solution
abdul_hakim
Active Contributor

‎2005 Nov 30 7:59 AM

0 Likes
1,587

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 akunnr = bkunnr.

2 REPLIES 2
Read only

Go to solution
Former Member

‎2005 Nov 30 7:57 AM

0 Likes
1,585

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

Read only

Go to solution
abdul_hakim
Active Contributor

‎2005 Nov 30 7:59 AM

0 Likes
1,588

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 akunnr = bkunnr.