topic Select query in Application Development and Automation Discussions

Select query

Former Member — Fri, 21 Dec 2007 02:39:42 GMT

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..

Re: Select query

former_member186741 — Fri, 21 Dec 2007 02:57:26 GMT

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.

Re: Select query

jayanthi_jayaraman — Fri, 21 Dec 2007 03:01:05 GMT

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').

Re: Select query

Former Member — Fri, 21 Dec 2007 03:05:07 GMT

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' ).

Re: Select query

former_member156446 — Fri, 21 Dec 2007 03:11:18 GMT

u can even build a range for mptyp..

but range might reduce the performance.