simple select query

[former_member97974]

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

[former_member611181]

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