Questions tagged as 'join'

Tagged questions
1
answer

Select from 3 tables mysql

I have a query that already brings information from 2 tables, but I need to add to the statement that brings me information from the table called locales to bring the name of the place that is identified with id from the table equipos...
asked by 23.08.2018 / 11:31
0
answers

Warning: sqlsrv_has_rows () expects parameter 1 to be resource, boolean given (using inner join)

I need help with this, I did not come across any surprises until I had to perform a inner join . It's the first time I use one with php. Maybe my syntax is incorrect. <!doctype html> <html> <head> <meta charset="utf-8">...
asked by 24.07.2018 / 03:41
1
answer

Why does not this query work in codeigniter, and in the IDE of ms Access it works without problem? (I think it's the JOIN)

I have a query that I can not work inside codeigniter, removing parts of the query, it seems that the error is in the JOIN, but I do not understand why, and even less understand, that when performing the query in PostMan, for example, it does n...
asked by 11.06.2018 / 08:02
1
answer

consult range of dates within a join in SQL

I need to filter my query for a specific day and along with other ranges within a join, I have this query, I hope someone can help me, thanks. select r.application as "Fecha transacción", r.id as "Id transacción", r.type_movement as "Tipo tran...
asked by 01.06.2018 / 23:11
1
answer

Join returns duplicate records mysql codeigniter

I'm doing a coansulta to 3 tables that have a common id, but it returns duplicate records twice each one of them public function select_informacion_encargados(){ $this->db->select('encargado.nombre, encargado.materno, encarga...
asked by 25.05.2018 / 07:59
0
answers

Show information that is not in another table

I am trying to bring data that is not found in another table with codeigniter My model: public function getEntradas($proveedor){ //Mostrar entradas del proveedor que no estan en pagos $this->db->select('...
asked by 10.05.2018 / 02:24
0
answers

inner join in mysql update with last record

I have the following table, when doing inee join this take (or place) the first result that it finds and I want it to take the last, is there a way to force or modify my query? (when supertoken_id is dated 06/02/2018 and id = 1116741)...
asked by 09.05.2018 / 23:01
1
answer

Show results from a query to three tables with INNER JOIN

I have a problem may be easier than I think but it really takes me several nights and I could not solve, the thing is that I have three related tables and I want to make a query that brings me data from each of them, I have the following tables,...
asked by 29.04.2018 / 21:21
2
answers

Problem with inner join sql

I'm going crazy, I've tried several databases and it does not work to see if you can help me. select 'Tienda.Codigo_de_barras' from "Tienda" inner join "Online" on 'Tienda.Codigo_de_barras' ='Online.Codigo_de_barras'; The code consists of...
asked by 21.04.2018 / 19:48
0
answers

Return null data from a subquery

I am working with MySQL making a list of top 100 keywords associated with scientific articles. The subquery basically provides the top 100 keywords along with the number of times that appear globally . Now, what I want is to filter by countr...
asked by 10.03.2018 / 17:47