select from as code example
Example 1: sql select from select
SELECT t1.*
FROM t1
WHERE t1.MY_FIELD = (SELECT t2.MY_FIELD
FROM t2
WHERE t2.MY_FIELD = t1.MY_FIELD);
Example 2: SELECT INTO
SELECT * INTO nome_da_tabela_que_estao_a_mexer_BKP
FROM nome_da_tabela_que_estao_a_mexer
Example 3: SELECT FROM
SELECT * FROM Customers;