Home sql How to combine columns from different tables in SQL

How to combine columns from different tables in SQL

Author

Date

Category

How do I concatenate the same columns in table 1 and table 2?

 enter image description here

I’ll try

INSERT INTO table_2 (users)
SELECT users
FROM table_1

but, it does not join, but inserts after the first table

 enter image description here


Answer 1

SELECT *
FROM Table1 t1 JOIN Table2 t2 ON t1.USERS = t2.USERS

Programmers, Start Your Engines!

Why spend time searching for the correct question and then entering your answer when you can find it in a second? That's what CompuTicket is all about! Here you'll find thousands of questions and answers from hundreds of computer languages.

Recent questions