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