试试这个：
SELECt--A bunch of columns from several tablesFROM prd_acct_cmp_grp pacgJOIN product_acct pa ON pacg.product_account_id = pa.product_account_idJOIN customer_acct ca ON pa.customer_acct_id = ca.customer_acct_idJOIN prd_acct_acct_cmp pac ON pacg.product_account_id = pac.product_account_id AND pacg.occurencce_number = pac.occurence_number AND pac.prcmp_pre = 'USAGE'LEFT JOIN (SELECt DISTINCT member_id, group_idFROM group_membersWHERe group_id IN (33158, 27156, 35376, 36217)) gm ON ca.customer_acct_id = gm.member_idLEFT JOIN sales_hierarchy sh ON ca.primary_sales_rep = sh.sales_rep_idLEFT JOIN sales_region sr ON sh.region_cd = sr.sales_region_preLEFT JOIN pacg_usage pu ON pacg.component_group_cd = pu.component_group_cd AND pacg.component_grp_val = pu.component_grp_valWHERe pacg.component_group_cd = 'AN' AND pacg.component_grp_val IN (%s) --string that is added in later
