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

Recommended Answers

All 4 Replies

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.