插入/选择查询

Question

Having trouble with the following query. Can anyone help coach me along?

Two tables: wa_list and wa_research.

wa_list is my standing table, wa_research is my staging table and once my research is complete I want to move those records researched to the wa_list table and update a column "wa_research.updated" to today's date in the format MM-DD-YYYY

INSERT INTO `wa_list` (exchange, symbol, security_name)
SELECT A.exchange, A.symbol, A.security_name
FROM `wa_research` A WHERE A.waID != 0 AND A.CIK = 0;

There are more fields, I just truncated them for simplicity. I'm thinking I can do it all in one query, but looking for a sanity check and guidance.

Answer 1

What is A in last line near the WHERE. It maybe the error. Put the error you getting.

Or use this

UPDATE
wa_research war,
wa_list wal
SET
war.columnName= wal.columnName
WHERE
war.columnName= SOMEVALUE;