how save a table with help of inner join

Question

everyone! I would like to save the table after I used INNER JOIN.

CREATE TABLE result AS (
SELECT  measures.Day,
SELECT  measures.Day,
    stations.Name,
    measures.name_measure,
    measures_of_stations.Count, 
    measures.unit
FROM
    measures_of_stations
    INNER JOIN
    stations
        ON measures_of_stations.id_station = stations.id_station
    INNER JOIN 
    measures
        ON measures_of_stations.id_measure = measures.id_measure)

But I have an error "Invalid syntax next to ( ". Why? Thank you in advance :)

score 1 · Answer 1 · answered Oct 07 '16 at 18:53

You need to use the INTO clause, see example below:

SELECT  measures.Day,
    stations.Name,
    measures.name_measure,
    measures_of_stations.Count, 
    measures.unit INTO result
FROM
    measures_of_stations
    INNER JOIN
    stations
        ON measures_of_stations.id_station = stations.id_station
    INNER JOIN 
    measures
        ON measures_of_stations.id_measure = measures.id_measure

score 0 · Answer 2 · answered Oct 07 '16 at 18:54

SELECT  measures.Day,
    stations.Name,
    measures.name_measure,
    measures_of_stations.Count, 
    measures.unit
INTO result
FROM
    measures_of_stations
    INNER JOIN
    stations
        ON measures_of_stations.id_station = stations.id_station
    INNER JOIN 
    measures
        ON measures_of_stations.id_measure = measures.id_measure

how save a table with help of inner join

2 Answers2