Posts by Giovani Silva • 21 points
4 posts
-
1
votes1
answer561
viewsA: Mysql SELECT with JOIN and LIMIT in child table
Personal good I got a simple solution, which is not exactly what I was looking for, but can break a branch. Remains open the search for a solution using (LIMIT) within the JOIN. Situation: Use of 2…
-
0
votes4
answers3541
viewsA: How to bring records of a LEFT JOIN even if not obeying the WHERE?
Hello, you can wear IF without the WHERE. You will bring all the results, being that IF meet the criterion (b.ano = 2016 AND b.mes = 2) returns the original value, otherwise NULL. *Separated with…
-
-1
votes2
answers1807
viewsA: INNER JOIN with equal fields in a table - Error: #1066 - Not Unique table/alias: 'tb_usuario'
Hi, most likely your error is in using (INNER JOIN tb_usuario ) 2 times. Because it does not create two tables (buyers, sellers) so they are separated. In your search I believe that every sale or…
-
1
votes1
answer561
viewsQ: Mysql SELECT with JOIN and LIMIT in child table
I have a table catalogo related to another table imagens. Each record in catalogo has N images. I need that in a SELECT with INNER JOIN imagens, only 3 images are returned for each table row…