Questions tagged as 'join'

Tagged questions
1
answer

Join results in SQL Server

I would like to know how I can do to join the results of several selects in the same temporary table if possible, or if there is another way to do it. This is the code that I have at the moment: Declare @mod as int; Declare modelos c...
asked by 26.12.2017 / 21:40
1
answer

Utility of "" .join ()

I would like to know the usefulness and functionality of this method (actually I do not know if it is a method) ".".join . I have seen it in several examples and forums but its concept has not yet become clear to me. If you could give me a...
asked by 24.09.2017 / 19:41
3
answers

Doubt with inner join

I have a database with two tables. One is the coche table and the ruta table: Table coche : pk_coche modelo ------------------- 1 Modelo 1 2 Modelo 2 3 Modelo 3 Table ruta...
asked by 16.04.2018 / 12:02
1
answer

Linq C # Outer Join Show the values that are not in the fields to compare

I have the following doubt, I hope you can help me. I have two tables, one of subjects and another that assigns the subjects to the students through their id. "Not all subjects have students assigned." They ask me to show with linq those subject...
asked by 17.02.2018 / 22:22
2
answers

Help JOINS ORACLE SQL query

Create a select where the name and last name of the employee, department where he works and the name and surname of the manager who coordinates it. SELECT EMPLOYEES.FIRST_NAME||' '||EMPLOYEES.LAST_NAME AS "NOMBRE COMPLETO DEL EMPLEADO",DEPARTM...
asked by 16.06.2018 / 08:08
1
answer

SQL query. Joins

Place value of a table2 in a query to table1. I have a query in SQL SELECT ROW_NUMBER() over (partition by IdCertificado order by FechaCambio) Consecutivo, upper (IdCertificado) IdCertificado , IdTipoSolicitud , cast (FechaCambio AS date)...
asked by 31.07.2018 / 21:50
1
answer

Problems with Pivot and Join SQL Server

Could someone tell me what I'm doing wrong? All the errors that mark me tell me the same thing    Expecting '(', or SELECT ( select distinct --periodo empleados.idempleado , conceptos.descripcion descripcion, valconceptos.valor, pe...
asked by 19.09.2018 / 02:31
1
answer

Query about SQL INNER JOIN SELECT TOP 1

I have the following question: in a table I have a ID that is related to the other table, but the daughter table has several ID of the table Father then at the time of doing the INNER JOIN brings me N records. I'm tr...
asked by 13.06.2017 / 18:55
2
answers

Select the record with the highest value within a JOIN

I have a procedure with SELECT with several JOINS and, in one of them, I need to extract only one result (the most recent date) when several results can really be given. In principle, the dates will never be exact since it is stored in...
asked by 23.01.2017 / 16:37
1
answer

Join in sqlalchemy

I am trying to pass a query that I have made - and I already tried it in SQL - to SQLAlchemy in python using Flask. This is the query in SQL: select Reclamo.IdReclamo from Reclamo,ServicioAsignacion,ReclamoServicioAsignacionAfectado where S...
asked by 23.09.2016 / 17:00