|
|
|
|
|
SELECT Com_Performance.*, Com_Information.cmpName, Com_Information.cmpPrincipal, Rotc_Quotation.報買價, Rotc_Quotation.報賣價, Rotc_Quotation.成交價 FROM Com_Performance INNER JOIN Com_Information ON Com_Performance.cmpNo = Com_Information.cmpNo LEFT OUTER JOIN (SELECT * FROM Rotc_Quotation WHERE (日期 = '2024/6/7 下午 03:37:00')) Rotc_Quotation ON Com_Information.cmpNo = Rotc_Quotation.cmpNo WHERE (Com_Information.cmpOpenType <= 3) AND (Com_Performance.年度 = N'2012') ORDER BY Com_Performance.本益比 將字元字串轉換成 smalldatetime 資料類型時,轉換失敗。 | |