Posts by Régis Neis • 13 points
3 posts
-
0
votes2
answers391
viewsQ: Bring the second and third line of a query
Oracle-SQL I have a chart that records the time records that each employee makes. The table contains the following information: (TABELA QUE ESTOU FAZENDO A CONSULTA) Contrato | Data | Hora 1 |…
-
0
votes3
answers55
viewsA: Relationship between tables varying according to value
I was able to work it out with the following guys. I made a select after from only to link with my tables: SELECT * FROM nfs n , (select pedido_entrega_id||pedido_entrega_id_origem entrega_id, id…
sqlanswered Régis Neis 13 -
1
votes3
answers55
viewsQ: Relationship between tables varying according to value
I have a chart that can record the id reference (FK) in more than one column. I need to make a select that links to the first reference column and if it is null, make the link through the second…
sqlasked Régis Neis 13