Answers for "how to insert on both table in join table"

SQL
1

insert value to new table by joining 2 different tables

INSERT INTO table ( col1 , col2, col3, col4)
SELECT p.col1, p.col2, c.col3, c.col4
FROM table1 p
INNER JOIN table2 c ON c.Id = p.Id
Posted by: Guest on September-03-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language