topic Re: select statement in Application Development and Automation Discussions

select statement

Former Member — Thu, 03 Jun 2010 17:44:18 GMT

Hello programmers,

I need to know how to write a select query in this given condition

select <f> from <t> into corresponding fields of itab

where <a> eq <b.a>

and < c > eq 'aaa'.

i want to take 3 values of <C> say 'aaa' 'bbb' 'ccc' ,

i tested more AND condition to it like

select <f> from <t> into corresponding fields of itab

where <a> eq <b.a>

and < c > eq 'aaa'

and < c > eq 'bbb'

and < c > eq 'ccc'.

but its not showing values .Please help.

Former Member — Thu, 03 Jun 2010 17:47:46 GMT

Hi,

It´s a very, very basic question...

Think about:

where

and < c > eq 'aaa'

and < c > eq 'bbb'

and < c > eq 'ccc'.

Never will occurs, because nothing is igual to 'aaa' and 'bbb' at same time!

use:

where

and ( < c > eq 'aaa' or < c > eq 'bbb' or < c > eq 'ccc' ).

Best regards,

Leandro Mengue

Former Member — Thu, 03 Jun 2010 19:12:52 GMT

Astonishingly basic question, but here goes....

where .....

and <c> in ('aaa', 'bbb', 'ccc').

ThomasZloch — Thu, 03 Jun 2010 20:35:48 GMT

Yes, I believe this is enough help, please always search for existing information before posting.

These forums are not meant to provide basic ABAP or general logic training.

Thread locked.

Thomas