试试这个。 select source_type, data_load_type from wc_table_inf where source_type not in ('EHUB','FOCUS','SAPReport') and data_load_type not in ('FULL','INCR');
你必须展开布尔逻辑 NOT (A and B) = NOT A OR NOT B ``` SELECT source_type ,data_load_type FROM wc_table_inf WHERE source_type NOT IN ( 'EHUB' ,'FOCUS' ,'SAPReport' ) OR data_load_type IN ( 'FULL' ,'INCR' );
2条答案
按热度按时间dw1jzc5e1#
试试这个。
select source_type, data_load_type from wc_table_inf where source_type not in ('EHUB','FOCUS','SAPReport') and data_load_type not in ('FULL','INCR');iyfamqjs2#
你必须展开布尔逻辑
NOT (A and B) = NOT A OR NOT B```SELECT source_type
,data_load_type
FROM wc_table_inf
WHERE source_type NOT IN (
'EHUB'
,'FOCUS'
,'SAPReport'
)
OR data_load_type IN (
'FULL'
,'INCR'
);