Skip to Content
0
Former Member
Mar 13, 2007 at 09:55 AM

or keyword

17 Views

hi,

may i know if or keyword in sql statement correct? if this field has empty or 0 value then will not select it. this is a char type. or any other way which is better than mine?

thanks.

SELECT axxx ayyy a~parob

INTO CORRESPONDING FIELDS OF wa_tab

FROM coep AS a INNER JOIN csks AS b ON aobjnr = bobjnr

WHERE

a~gjahr = p_gjahr AND

b~kostl IN s_kostl AND

a~parob <> '' OR

a~parob <> '0'.