Member Avatar for Yanny_1

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

  • 3 Contributors
  • 4 Replies
  • 138 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by theHop
Member Avatar for pritaeas

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

Member Avatar for Yanny_1

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'?

Member Avatar for pritaeas 
INSERT INTO tblsales (the columns you want to copy here)
SELECT the columns you want to copy here FROM tblsalesdummy
Member Avatar for theHop

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.