插入选择但有额外值？ [英] Insert Select but with extra values?

问题描述

嗨
我有一个插入选择查询，工作正常 -

Hi I have an Insert Select query with works fine -

INSERT tblASXhistoricals (StockID,TradeTime)
SELECT tblStockPrice.StockID,TradeTime)
FROM tblStockPrice INNER JOIN tblStock ON tblStock.StockID = tblStockPrice.StockID
WHERE tblStock.RIC LIKE '%.AX'

我希望在查询中插入单独的手动值，但根本不知道如何执行此操作。

我需要使用VALUES将值插入arcTime字段，但当然这不是工作。正确的语法是什么？

I wish to insert a separate manual value into the query but not at all sure how to do this.
I need to insert a value into the arcTime field as below using VALUES but of course this doesn't work. What would the correct syntax be?

INSERT tblASXhistoricals (arcTime,StockID,TradeTime)
VALUES ('xxxx',SELECT tblStockPrice.StockID,TradeTime)
FROM tblStockPrice INNER JOIN tblStock ON tblStock.StockID = tblStockPrice.StockID
WHERE tblStock.RIC LIKE '%.AX'

谢谢...

Thanks...

推荐答案

取消。

通过在选择行中输入文本值来计算出来 -

Cancel that.
Figured it out by just entering the text value into the Select line-

INSERT tblASXhistoricals (arcTime,StockID,TradeTime,OpenPrice,HST_Close,Bid,Ask,LastTrade,Volume) 
SELECT 'mmm',tblStockPrice.StockID,TradeTime,OpenPrice,HST_Close,Bid,Ask,LastTrade,Volume 
FROM tblStockPrice INNER JOIN tblStock ON tblStock.StockID = tblStockPrice.StockID 
WHERE tblStock.RIC LIKE '%.AX'

无论如何，谢谢

Thanks anyway

这篇关于插入选择但有额外值？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！