Name table resulting from SELECT

Question

Name table resulting from SELECT

Navigation

#1 by (1 votes)

0

I need to do a SELECT of the resulting table from another SELECT , but I need to reference it in ON INNER JOIN in>. How do I do this in Oracle (PL / SQL)? I tried this way, but it did not work:

SELECT * FROM (SELECT * FROM recurso WHERE tipo = 'CID') AS cidade INNER JOIN hierarquia ON hierarquia.recurso = cidade.codigo;

sql oracle

asked by anonymous 22.11.2017 / 14:53

1 answer

Upload multiple to PHP online server Decreasing the value of two fields of a table and sorting according to the result

score 1 · Accepted Answer

You should position Subselect in front of INNER JOIN and then you can give your selection a nickname as if it were a table.

SELECT * 
FROM hierarquia 
INNER JOIN (
   SELECT *
   FROM recurso 
   WHERE tipo = 'CID'
) Cidade
ON Cidade.codigo = hierarquia.recurso

SQLFiddle - Online sample