topic Re: Select query where codn in Application Development and Automation Discussions

Select query where codn

Former Member — Mon, 01 Sep 2008 07:05:25 GMT

Hi in my select query in the where codn i have to give fields from different tables.How to write it?

Re: Select query where codn

Former Member — Mon, 01 Sep 2008 07:07:23 GMT

Hi Hema,

loop the tables and use SELECT query in that .

But this will be performance issue.

Best regards,

raam

Re: Select query where codn

Former Member — Mon, 01 Sep 2008 07:08:40 GMT

Hi Hema,

Please go through the following information :

Specifying Two or More Database Tables as a Left Outer Join

In an inner join, a line from the left-hand database table or join is only included in the selection if there is one or more lines in the right-hand database table that meet the ON condition <cond>. The left outer join, on the other hand, reads lines from the left-hand database table or join even if there is no corresponding line in the right-hand table.

Example :

SELECT  p~carrid p~connid f~fldate b~bookid
  INTO  CORRESPONDING FIELDS OF TABLE itab
  FROM  ( ( spfli AS p
            INNER JOIN sflight AS f ON p~carrid = f~carrid AND
                                       p~connid = f~connid    )
            INNER JOIN sbook   AS b ON b~carrid = f~carrid AND
                                       b~connid = f~connid AND
                                       b~fldate = f~fldate     )
  WHERE p~cityfrom = 'FRANKFURT' AND
        p~cityto   = 'NEW YORK'  AND
        f~seatsmax > f~seatsocc.

Regards,

Swapna.

Re: Select query where codn

Former Member — Mon, 01 Sep 2008 07:09:41 GMT

Hi I assume you are writing select quiry for inner join on multiple DB tables. In that case you need to write as some thing as below.

mara_{matnr in s_matnr AND marc}werks eq p_werks.....

Hope this will help,

Rama.

Re: Select query where codn

Former Member — Mon, 01 Sep 2008 07:11:06 GMT

hii

you can use JOIN statement for different fields in where conditions

SELECT
 likp~vbeln
likp~vstel
likp~lfart
likp~erdat
likp~wadat
likp~kunnr
lips~matnr
lips~lfimg
lips~meins
INTO TABLE itab FROM likp
INNER JOIN lips ON (lips~vbeln = likp~vbeln)
inner join vbuk on (likp~vbeln = vbuk~vbeln)
WHERE likp~erdat IN s_erdat 
and likp~vstel in p_vstel 
and likp~lfart in p_lfart
and vbuk~fkstk ne 'C'.

regards

twinkal

Re: Select query where codn

Former Member — Mon, 01 Sep 2008 08:01:53 GMT

HI,

The solution of your problem is JOIN .

u can use join to take field from different table

hope it will help you.............