Hi all,
I want to copy the join of two tables into another table. I tried the following approach but I have error
insert into new_copy values (ID,name,na_name)
SELECT
name
FROM
country u
INNER JOIN
(
SELECT
na_name
FROM
country2 st
)
s
ON
u.id = s.ID;