Join Query in one with JOIN [closed]

Question

Join Query in one with JOIN [closed]

Navigation

#1 by (2 votes)

1

I'm trying to merge several SQL statements into one, the problem is that it has a JOIN and I do not know how to rename tables

 SELECT users.nombre,users.apellido,users.id,
 COUNT(ligauruguaya_v.primero) AS Primero  FROM users LEFT JOIN
 ligauruguaya_v ON users.id = ligauruguaya_v.primero WHERE
 users.categoria < 3  GROUP BY users.id

 SELECT users.nombre,users.apellido,users.id,
 COUNT(ligauruguaya_v.segundo) AS Segundo FROM users LEFT JOIN
 ligauruguaya_v ON users.id = ligauruguaya_v.segundo WHERE
 users.categoria < 3  GROUP BY users.id

 SELECT users.nombre,users.apellido,users.id,
 COUNT(ligauruguaya_v.tercero) AS Tercero FROM users LEFT JOIN
 ligauruguaya_v ON users.id = ligauruguaya_v.terceroWHERE
 users.categoria < 3  GROUP BY users.id

that would be the sentences one by one but I need it to be in one ...

SELECT users.nombre,users.apellido,users.id, COUNT(ligauruguaya_v.primero) AS Primero, COUNT(ligauruguaya_v.segundo) AS Segundo, COUNT(ligauruguaya_v.tercero) AS Tercero, 
        FROM users 
        LEFT JOIN ligauruguaya_v ON users.id = ligauruguaya_v.primero,
        LEFT JOIN ligauruguaya_v ON users.id = ligauruguaya_v.segundo,
        LEFT JOIN ligauruguaya_v ON users.id = ligauruguaya_v.tercero
        WHERE users.categoria < 3 
        GROUP BY users.id

and the error it gives me is:

1066 - Table / alias: 'ligauruguaya_v' is not unique

I tried with ligauruguaya_v AS pepe, etc. but I did not make it

mysql sql query

asked by Alejandro Muñoz Schumacher 24.03.2018 в 18:08

source

1 answer

problem generating css with node-sass Charges well with the laravel server but does not load with xampp

score 2 · Answer 1

SELECT users.nombre,users.apellido,users.id, COUNT(pepe.primero) AS Primero, COUNT(pep.segundo) AS Segundo, COUNT(pe.tercero) AS Tercero
            FROM users 
            LEFT JOIN ligauruguaya_v AS pepe ON users.id = pepe.primero
            LEFT JOIN ligauruguaya_v AS pep ON users.id = pep.segundo
            LEFT JOIN ligauruguaya_v as pe ON users.id = pe.tercero
            WHERE users.categoria < 3 
            GROUP BY users.id

Surely I had some bad coma