Hi! Anyone can help me about my problem on HOW TO UPDATE TABLE USING THE CONTENTS FROM ANOTHER TABLE?

Thank you in advance for those who can help me.

Anyway, I'm using VB.Net 2010

I hope you guys can help

Can you give an example of what you are trying to achieve?

I've resolved this problem, now I have another.. here it goes

I have two tables 'tblsales' and 'tblsalesdummy'
How can I transfer the contents of the 'tblsalesdummy' to 'tblsales'?

INSERT INTO tblsales (the columns you want to copy here)
SELECT the columns you want to copy here FROM tblsalesdummy

SELECT * INTO tblsales
FROM tblsalesdummy