Skip to Content
0
Former Member
Dec 21, 2007 at 02:39 AM

Select query

25 Views

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