topic Re: select statement in Application Development and Automation Discussions

select statement

Former Member — Thu, 31 Jul 2008 08:15:16 GMT

hi guyz,

im wondering if therez anyway to compare two values for the same field in the where condition of select statement. plz advise..

thanks

Re: select statement

Former Member — Thu, 31 Jul 2008 08:20:06 GMT

Use-

select xyz

from xyz

into xyz

where ( field eq value1 or field eq value2 )

Regards,

Aparna Gaikwad

Re: select statement

Former Member — Thu, 31 Jul 2008 08:20:25 GMT

Hi,

You can use two times the same field in the where clause with different values for the field.

Thanks

Sudharshan

Re: select statement

JozsefSzikszai — Thu, 31 Jul 2008 08:20:38 GMT

hi,

did you try?

SELECT ...

WHERE ( field EQ a OR field EQ b )

or is it not your question?

Re: select statement

Former Member — Thu, 31 Jul 2008 08:20:49 GMT

Hi,

If you are talking about specifying two values for the same field in the WHERE condition in the SELECT statement, Yes it is possible.


update sflight
   set fldate = w_date
 where carrid in ('AA','LH')
   and connid in ('0010','0011').

If you want to compare two fields in the Select statement,


SELECT

WHERE (CARRID EQ 'AA' OR CARRID EQ 'LH').

Re: select statement

Former Member — Thu, 31 Jul 2008 08:21:22 GMT

hiii

yse you can use it like below query.

SELECT matnr                         " Material Number
    FROM mara
    INTO TABLE i_mara
   WHERE matnr = '000000000000002132'
      OR matnr = '000000000000002137'.

regards

twinkal

Re: select statement

vinod_vemuru2 — Thu, 31 Jul 2008 08:21:29 GMT

Hi,

Yes we can do it using IN operator.

SELECT...FROM ... INTO TABLE ....

WHERE field IN ( 'Value1' , 'value2' )

AND....

Thanks,

Vinod.

Re: select statement

Former Member — Thu, 31 Jul 2008 08:21:40 GMT

hi,

use self mapping using Alias.

1.make an inner join of a table with alias *a* once and *b* again.

2.Now compare a-field EQ b-field.

Regards,

anirban

Re: select statement

Former Member — Thu, 31 Jul 2008 08:22:03 GMT

Hi!

SELECT * FROM mara

INTO TABLE gt_mara

WHERE matnr ='A' OR matnr = 'B'.

Regards

Tamá

Re: select statement

Former Member — Thu, 31 Jul 2008 08:22:09 GMT

Hi,

Select * from mara
       into table gt_mara
       where MTART IN ( 'ZA' , 'ZB' ).

Best regards,

Prashant

Re: select statement

Former Member — Thu, 31 Jul 2008 08:36:37 GMT

HI,

Yes, you can compere two values for the same field in WHERE clause of SELECT statement.

SELECT <field1> <field2>... from <table> into table <Internal Table> where

<field1> = <val1> OR

<field1> = <var2> OR

<field1> = <val3>.

SELECT <field1> <field2> ... from <table> INTO TABLE <internal table> where

<field1> IN <val1, val2, val3 ...).

Hope this will be useful.

Cheers

Ramaraju