simple select query

former_member97974 — Tue, 15 Sep 2009 19:11:07 GMT

dear all please tell me what is the meaning of AND e~serviceid NOT IN ('PE_DEFAULT', 'PG_DEFAULT')

SELECT i_{anlage e}service_start

INTO TABLE i_data

FROM eservice AS e

JOIN euiinstln AS i

ON i_{mandt = e}mandt

AND i_{int_ui = e}int_ui

WHERE e~service IN ('ESUP','GSUP')

AND e~service_end = c_max_date

AND e~serviceid NOT IN ('PE_DEFAULT', 'PG_DEFAULT')

AND e~service_start IN s_date

AND i~anlage IN s_anlage.

thnkx in advance

Moderator message - Please do not ask or answer basic questions/ Press F1 on SELECT or search the forum instead - thread locked

Edited by: Rob Burbank on Sep 15, 2009 4:02 PM

Re: simple select query

former_member611181 — Tue, 15 Sep 2009 19:14:28 GMT

AND e~serviceid NOT IN ('PE_DEFAULT', 'PG_DEFAULT') means do not pick data if service ids are 'PE_DEFAULT' or 'PG_DEFAULT'.