oracle - select script with detail of all the tables

0

I am developing a query to 3 tables which contains the fields name and code and I would like to make a selection of these by bringing the data as follows:

  • Table1Code
  • Table1Codigo.Table2Codigo
  • Table1Codigo.Tabla2Codigo.Tabla3Codigo
  • Table1Codigo.Tabla2Codigo.Tabla3Codigo

Someone can give me a guideline on the correct sentence that I should use to create the select.

    
asked by Giovanni Esteban Beltran Avila 24.08.2017 в 06:04
source

1 answer

0

I do not fully understand how you want to show the result, but the following simple SQL returns the data.

SELECT nombre, codigo FROM Tabla1, Tabla2, Tabla3
    
answered by 24.08.2017 в 09:10