yvrpwl

Thanks for sharing

den_c

thank you very much.

wwx111111

SET STATISTICS io ON
        SET STATISTICS time ON
        Go
SELECT up.project_id, up.lab_id, up.user_id, up.title, up.key_word, up.project_abstract, up.model_name, up.case_num, up.create_time, up.project_type, ul.lab_name, uu.userName, isnull(ut.trade_vol,0) as trade_vol FROM ui_project_info AS up LEFT OUTER JOIN                ui_user AS uu ON up.user_id = uu.userId LEFT OUTER JOIN ui_lab_info AS ul ON up.lab_id = ul.lab_id                                     LEFT OUTER JOIN (SELECT COUNT(*) AS trade_vol, seller_project_id FROM  ui_case_trade_log                                       GROUP BY seller_project_id) AS ut ON ut.seller_project_id = up.project_id where 1 = 1 and user_id =20 and up.lab_id =1   
         
        go
        SET STATISTICS profile OFF
        SET STATISTICS io OFF
        SET STATISTICS time OFF



USE [sed]
GO

orcad1

thanks

wahgo

thanks

44566123

辛苦了

dio900

thank for the sharing

khmichael

thank

nktso5

thanks for sharing

pokman

thanks!

fhcyip

thank you for sharing

targ

Thanks for sharing.

沙鸥

thank you

奔着

顶顶顶顶顶顶

sanque

thank you