thank you very much.作者: wwx111111 時間: 2018-1-3 11:27 AM
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 時間: 2018-1-3 11:42 AM
thanks作者: wahgo 時間: 2018-1-3 12:34 PM
thanks作者: 44566123 時間: 2018-1-3 05:04 PM
辛苦了作者: dio900 時間: 2018-1-3 07:08 PM
thank for the sharing作者: khmichael 時間: 2018-1-3 08:28 PM
thank作者: nktso5 時間: 2018-1-4 03:46 AM
thanks for sharing作者: pokman 時間: 2018-1-4 05:59 AM
thanks!作者: fhcyip 時間: 2018-1-4 12:26 PM
thank you for sharing作者: targ 時間: 2018-1-4 04:21 PM