Skip to Content
0
Former Member
Oct 13, 2006 at 04:59 PM

Select Statement.

32 Views

i need to compare two status and then diplay how should i do that.

if the stat - 'I0002' , stat - 'I0042'.

if the object id is having both the stat then only i need to display it.

how should i write the select statement.

SELECT SINGLE * INTO I_JEST FROM JEST

WHERE OBJNR = I_TMP_CAUFV-OBJNR and STAT IN ('I0002','I0042')