How to join a table to a query in Impala?

Question

SQL

Hello.
I want to join a table in Impala to a query:
CREATE TABLE p_1 stored AS parquet AS
SELECT a. m_rk,
a1.mod
AS t1
FROM p_c a
LEFT JOIN p_1 a1
WHERE a.re = 1

FULL JOIN p_2 t2
ON t1.m_rk = t2.m_rk;
I already have an error here, but I also wanted to attach another field calculated on the basis of one of the fields to the resulting table.
Please tell me how can I fix the error.
Thank you.