Hello, I'm having a question about a select chained. I found many examples with
select * from (select campo from tabela)
However I want to define the fields of my query, as below:
select campo1,campo2,(select campo1 from tabela2) from tabela1
The point is that within select I need a where with a column displayed
select campo1,campo2,(select campo1 from tabela2 where id=campo1) from tabela1
How can I index to fetch through another column?