求助一条sql语句的问题.

magicangel

http://www.itpub.net/showthread.php?s=&threadid=162263

bka

郁闷...报错是不报了...问题是重复的记录还是一大堆...

bka

select DISTINCT p.productid,p.product_name,p.Field_8,p.Field_7,p.Field_5,p.mem_price,p.frist_date,p.catalogid,p.type_id,p.is_index,p.is_top,t.id,t.typename,t.gain from t_business_product_1 p,t_business_type t where me_ver='cn' and p.type_id=t.id and p.Field_7 like '%123%' or p.Field_8 like '%123%'