topic Re: hi all in Application Development and Automation Discussions

hi all

Former Member — Mon, 13 Aug 2007 08:36:06 GMT

my question is : is it possible to have 'inner join' with 'select single' statement???

thanx

rocky

Re: hi all

Former Member — Mon, 13 Aug 2007 08:39:26 GMT

yes u can

You can read data from more than one database table in a single SELECT statement by using inner or left outer joins in the FROM clause.

The disadvantage of using joins is that redundant data is read from the hierarchically-superior table if there is a 1:N relationship between the outer and inner tables. This can considerably increase the amount of data transferred from the database to the application server. Therefore, when you program a join, you should ensure that the SELECT clause contains a list of only the columns that you really need. Furthermore, joins bypass the table buffer and read directly from the database. For this reason, you should use an ABAP Dictionary view instead of a join if you only want to read the data.

The runtime of a join statement is heavily dependent on the database optimizer, especially when it contains more than two database tables. However, joins are nearly always quicker than using nested SELECT statements.

reward points to all helpful answers

kiran.M

Re: hi all

seshatalpasai_madala — Mon, 13 Aug 2007 08:41:43 GMT

Hi,

YES this should not be a problem, make sure to give the WHERE clause in a such a way that you donot read more than one record from Database.

Regards,

Sesh

Re: hi all

Former Member — Mon, 13 Aug 2007 08:42:12 GMT

yes...

check this sample..

select single a_{vbeln b}kunnr

into (lips-vbeln, vbak-kunnr)

from lips as a

inner join vbak as b

on ( b_{vbeln eq a}vgbel )

where a_{vbeln eq b}vbeln.

reward if it helps..

regards,

Omkar.

Re: hi all

Former Member — Mon, 13 Aug 2007 08:42:12 GMT

Hi,

Yes,it is Possible.

Pls Check the Following Code,

TABLES: likp,lips,vbak.

SELECT SINGLE lips_{vbeln vbak}kunnr

FROM lips

INNER JOIN vbak

ON ( vbak_{vbeln EQ lips}vgbel )

INTO (lips-vbeln,vbak-kunnr)

WHERE lips~vbeln EQ likp-vbeln.

Regards,

Padmam.

Re: hi all

Former Member — Mon, 13 Aug 2007 08:43:33 GMT

Here is a sample code...........

PARAMETERS: p_cityfr TYPE spfli-cityfrom,

p_cityto TYPE spfli-cityto.

DATA: BEGIN OF wa,

fldate TYPE sflight-fldate,

carrname TYPE scarr-carrname,

connid TYPE spfli-connid,

END OF wa.

DATA itab LIKE SORTED TABLE OF wa

WITH UNIQUE KEY fldate carrname connid.

SELECT c_{carrname p}connid f~fldate

INTO CORRESPONDING FIELDS OF TABLE itab

FROM ( ( scarr AS c

INNER JOIN spfli AS p ON p_{carrid = c}carrid

AND p~cityfrom = p_cityfr

AND p~cityto = p_cityto )

INNER JOIN sflight AS f ON f_{carrid = p}carrid

AND f_{connid = p}connid ).

LOOP AT itab INTO wa.

WRITE: / wa-fldate, wa-carrname, wa-connid.

ENDLOOP.

Regards,

Pavan

Re: hi all

Former Member — Mon, 13 Aug 2007 08:48:16 GMT

Hello,

U can use select single with Inner join

See the sample code

Fetch data by joining KNVV & KNA1 and based on selection criteria

<b> SELECT single a_{kunnr b}vkorg FROM kna1 AS a

INNER JOIN knvv AS b ON a_{kunnr = b}kunnr

INTO corresponding fields of wa_knvv

WHERE b~vkorg = p_vkorg.</b>

Regards,

LIJO JOHN.