Select query

[Former Member]

Hi,

I need to write a select query that satisfies the condition for

mpobj,

inact

psort..

as well as the field mptyp can

be 'I' 'W' 'U'.

How to write the query...

Can we use

select......

and

mptyp in( 'I','W','U').

kindly help...

Plz help me in rectifying the error in the following query.

SELECT point psort mptyp

INTO (imptt-point, imptt-psort, imptt-mptyp)

FROM imptt

WHERE mpobj = v_equnr

AND inact <> 'X' " do not accept inactive meas. pt

AND psort LIKE '%'

AND mptyp IN ( 'U','I','W' ).

Thanks..

[former_member186741]

SELECT point psort mptyp

INTO (imptt-point,imptt-psort,imptt-mptyp)

FROM imptt

WHERE mpobj = v_equnr

AND inact = 'X'

AND psort LIKE '%'

AND mptyp IN ('U','I','W' ).

endselect.

[jayanthi_jayaraman]

Hi,

SELECT point psort mptyp

INTO (imptt-point, imptt-psort, imptt-mptyp)

FROM imptt

WHERE mpobj = v_equnr

AND inact 'X' " do not accept inactive meas. pt

AND psort LIKE '%'

AND mptyp IN ('U','I','W').

[Former Member]

SELECT point psort mptyp

INTO (imptt-point, imptt-psort, imptt-mptyp)

FROM imptt

WHERE mpobj = v_equnr

AND inact = 'X'

AND mptyp IN ( 'U','I','W' ).

[former_member156446]

u can even build a range for mptyp..

but range might reduce the performance.