Changes between Version 9 and Version 10 of Ticket #101


Ignore:
Timestamp:
04/23/2012 06:13:12 PM (14 years ago)
Author:
chenchongqi
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #101 – Description

    v9 v10  
    8989where z.company_id = a.user_id and z.brand_id = a.type_id and z.small_type_id = c.id and z.big_type_id = c.parent_id 
    9090) 
     91-- 删除不符合的关系,包括已删除、否决等 
     92delete from ent_company_product_line a 
     93where not exists(  
     94select b.id from ent_product b, ent_product_item c 
     95where b.id = c.company_product_id and a.company_id = b.user_id and a.brand_id = b.type_id 
     96and c.status <=1 
     97) 
    9198}}}