topic Re: selecting fields from 2 different tables with single select query.. in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/selecting-fields-from-2-different-tables-with-single-select-query/m-p/1026055#M82463 <HTML><HEAD></HEAD><BODY><P>Hi Naveen,</P><P>You can do in ABAP Very well using Joins...</P><P></P><P>eg.</P><P> </P><P>SELECT a~kunnr</P><P> a~name1</P><P> b~pernr</P><P> INTO TABLE itab</P><P> FROM kna1 AS a</P><P> INNER JOIN knvk AS b</P><P> ON a<SUB>kunnr = b</SUB>kunnr.</P></BODY></HTML> Wed, 30 Nov 2005 07:59:18 GMT abdul_hakim 2005-11-30T07:59:18Z selecting fields from 2 different tables with single select query.. https://community.sap.com/t5/application-development-and-automation-discussions/selecting-fields-from-2-different-tables-with-single-select-query/m-p/1026053#M82461 <HTML><HEAD></HEAD><BODY><P>hi...</P><P>can we select fields from two different tables in a single select query... under some where condition for both the tables... </P><P>the same thing can be done in sql what about in abap...</P><P>thanks...</P></BODY></HTML> Wed, 30 Nov 2005 07:56:03 GMT https://community.sap.com/t5/application-development-and-automation-discussions/selecting-fields-from-2-different-tables-with-single-select-query/m-p/1026053#M82461 Former Member 2005-11-30T07:56:03Z Re: selecting fields from 2 different tables with single select query.. https://community.sap.com/t5/application-development-and-automation-discussions/selecting-fields-from-2-different-tables-with-single-select-query/m-p/1026054#M82462 <HTML><HEAD></HEAD><BODY><P>Yes,</P><P>By using joins we can select feilds from 2 different tables, criteria is the tables must have a common key amontg them.</P><P></P><P>Regards,</P><P>Raghav</P></BODY></HTML> Wed, 30 Nov 2005 07:57:56 GMT https://community.sap.com/t5/application-development-and-automation-discussions/selecting-fields-from-2-different-tables-with-single-select-query/m-p/1026054#M82462 Former Member 2005-11-30T07:57:56Z Re: selecting fields from 2 different tables with single select query.. https://community.sap.com/t5/application-development-and-automation-discussions/selecting-fields-from-2-different-tables-with-single-select-query/m-p/1026055#M82463 <HTML><HEAD></HEAD><BODY><P>Hi Naveen,</P><P>You can do in ABAP Very well using Joins...</P><P></P><P>eg.</P><P> </P><P>SELECT a~kunnr</P><P> a~name1</P><P> b~pernr</P><P> INTO TABLE itab</P><P> FROM kna1 AS a</P><P> INNER JOIN knvk AS b</P><P> ON a<SUB>kunnr = b</SUB>kunnr.</P></BODY></HTML> Wed, 30 Nov 2005 07:59:18 GMT https://community.sap.com/t5/application-development-and-automation-discussions/selecting-fields-from-2-different-tables-with-single-select-query/m-p/1026055#M82463 abdul_hakim 2005-11-30T07:59:18Z