Updating a Table

[txwylde]

I am trying to update a temp table by querying the values of another table. Here is my SQL:

insert into bi_kinkead.vietnam_fraud v
select * from bi_warehouse.archive_order_summary a where a.sales_order_num in ("7055089764", "7055106301", "7055218969", "7055220663", "7055233089", "7055283807", "7055281178", "7055270986", "7055254465", "7055029228", "7055246252", "7055024871", "7055089197", "7055180568", "7055244652", "7055306288", "7055308993", "7055230109", "7055193295", "7055317147", "7055109152", "7055110293", "7055110624", "7055110778", "7055111127", "7055111167", "7055112063", "7055112371", "7055187147", "7055187652", "7055188098", "7055188325", "7055306886", "7055307895", "7055308091", "7055107922", "7055231518", "7055343279", "7055259123", "7055259678", "7055259922", "7055305855", "7055308200", "7055101924", "7055103175", "7055103700", "7055104542", "7055035046", "7055037649", "7055037682", "7055310596");

I keep getting errors. I am a bit lost why I keep getting errors.

Thanks!
Bill

 

[txwylde]

Ahh.. once I took out the alias it was fine. I was just not thinking.