Questions tagged as 'join'

Tagged questions
4
answers

NULL the duplicate values of a LEFT JOIN Msql query

I have 2 tables. The first returns the order number and the two-state times Pedido TiempoPreparar TiempoAsignar ------------------------------------------- P001 10 9 P002 20 5 P003...
asked by 03.05.2018 / 19:21
4
answers

Bring data from a table whose date is less than the smallest in another table

I want to do an SQL query to see certain 'inconsistencies' in a SQLServer database. To simplify it a bit, let's say that I have a table Movimiento_Paciente that contains a field pacienteId and another fechaInicio . In this...
asked by 25.10.2018 / 15:15
2
answers

MySQL returns "# 1054 - The column 'person.type' in on clause is unknown"

I have this sentence: SELECT registro_vehiculo.fecha_entrada, persona.nombre,tipo_servicio.tipo_servicio FROM registro_vehiculo,persona,tipo_servicio INNER JOIN tipo_persona ON tipo_persona.id_tipop=persona.tipo WHERE registro_vehiculo.fech...
asked by 08.06.2017 / 14:59
4
answers

Inner join query to display the name with the id in two PHP tables

I have two tables, one call articulos , and another call categorias . In table articulos a column called id_categoria saves the ID of the categories available in the table categorias , and I want to show by the...
asked by 20.12.2018 / 04:11
1
answer

Problem with joins among database students subjects

I am studying the types of joins and doing exercises, I can do the inner joins without problems, but I have difficulty with the other variants such as the left join, in my example I have created a small and simple database. Data entered...
asked by 13.07.2016 / 05:03
1
answer

Help with a JOINS in 2 tables in MySQLi in PHP

I commented to them I have read several times the blog of link but I can not implement a JOINS in my project, what I have so far works perfectly but I'm doing 2 or 3 queries and the idea is to optimize the queries to my database for logical...
asked by 12.10.2018 / 18:24
1
answer

Problems with merge and dplyr

I am joining two data.frames huge by a common variable using merge , and the data.frame final% has many more lines than the initial ones, which suggests that you are duplicating observations. I'm using: df3 <- merge(df1, df2,...
asked by 26.06.2018 / 09:16
2
answers

SQL Select inner join

I have this problem that according to me I made a query to get only one answer row, but for some reason I get the same record several times, can someone tell me what I'm doing wrong? select [Nombre de Obra], Estado = case...
asked by 17.10.2018 / 20:02
3
answers

Query with inner join and LIKE operator

I have the following tables with their respective data Table1 +----------+------------+ | IdTabla1 | Velocidad1 | +----------+------------+ | 1 | 123.51 | | 2 | 123.55 | | 3 | 125.23 | | 4 | 125.87...
asked by 11.08.2018 / 10:05
2
answers

JoinS About the same Table with Null Values

You are trying to perform two JOINS to match the information of two tables, the first table contains a catalog of articles. id_art desc ------------------------ A1 Articulo A1 A2 Articulo A2 A3 Articulo A3...
asked by 11.05.2017 / 21:08