need help on database perform

[devastator]

hi all

 

 

 

 

 

i have

$products_new_query_raw = "select p.ptc_id, p.ptc_cust_id, p.ptc_name, p.ptc_link, p.ptc_qty_left, p.ptc_timer, p.ptc_reward, p.ptc_status from " . TABLE_CUSTOMERS_PTC . " p where p.ptc_status = '1' order by p.ptc_reward DESC";

 

 

-----------------------------------------------------------------

in a second table -- customers_ptc_done

 

ID CUST_ID PTC_ID

1 27 19

2 04 14

3 04 19

------------------------------------------------------------------

 

 

i want to select p.ptc_id who dont have been click by CUST_ID 27