Join Table to Result Set

執行 SQL 工作

• ConnectionType 屬性：OLE BD

• Connection 屬性：Stock_API

• SQLSourceType 屬性：直接輸入

• SQLStatement 屬性

SELECT  Stock_Chart.ApiDatetime
       ,Stock_Chart.StockNo
       ,MinAvgOpenPrice
       ,MinAvgHighPrice
       ,MinAvgLowPrice
       ,MinAvgClosePrice
       ,MinAvgVolume
       ,DayHighPrice
       ,DayHighTime
       ,DayLowPrice
       ,DayLowTime
FROM Stock_Chart
LEFT JOIN Stock_Quote ON Stock_Chart.StockNo = Stock_Quote.StockNo

• ResultSet 屬性：完整結果集（結果名稱：0；變數名稱：User::SqlResultSet）