Problems with SQL query with multiple tables

Question

I have 3 tables related, and I need to make a Query inside another Query joining them, this is what I got so far:

SELECT a.idarticulo,
       a.idcategoria,
       c.nombre as categoria,
       a.idarticulo,
       a.idsucursal,
       s.nombre as sucursal,
       (SELECT talla.idtalla,
               talla.nombre,
               articulo_talla.idtalla,
               articulo_talla.cantidad,
               articulo_talla.idarticulo,
               articulo.idarticulo,
               articulo.nombre
        FROM talla
               JOIN articulo_talla ON talla.idtalla = articulo_talla.idtalla
               JOIN articulo ON articulo_talla.idarticulo = articulo.idarticulo
        WHERE articulo.idarticulo = a.idarticulo) as tallaCantidad,
       a.codigo,
       a.nombre,
       a.stock,
       a.descripcion,
       a.imagen,
       a.condicion
FROM articulo a
       JOIN categoria c ON a.idcategoria = c.idcategoria
       JOIN sucursal s ON a.idsucursal = s.idsucursal
ORDER BY idarticulo DESC

But it throws me the following error: #1241 - Operand should contain 1 column(s)

Thanks for your help

Please format your code. It's really hard to make the query out as it is presented here. — Mureinik
– Mureinik, Commented Sep 11, 2018 at 18:31
Hi, and welcome to SO. Please see Why should I provide an MCVE for what seems to me to be a very simple SQL query — Strawberry
– Strawberry, Commented Sep 11, 2018 at 18:35
What part of the error message do you not understand? You have a scalar subquery, but it is returning too many values. It can only return one value. — Gordon Linoff
– Gordon Linoff, Commented Sep 11, 2018 at 22:13

DanB · Accepted Answer · 2018-09-11 18:34:26Z

1

Your subselect contains multiple columns. If you need only tallaCantidad :

SELECT a.idarticulo,a.idcategoria,c.nombre as categoria, a.idarticulo,a.idsucursal,s.nombre as sucursal,
(SELECT talla.idtalla, talla.nombre, articulo_talla.idtalla, articulo_talla.cantidad, articulo_talla.idarticulo, articulo.idarticulo, articulo.nombre
FROM talla
    INNER JOIN articulo_talla ON talla.idtalla=articulo_talla.idtalla
    INNER JOIN articulo ON articulo_talla.idarticulo=articulo.idarticulo
    WHERE articulo.idarticulo=a.idarticulo) as tallaCantidad, a.codigo,a.nombre,a.stock,a.descripcion,a.imagen,a.condicion
FROM articulo a
INNER JOIN categoria c ON a.idcategoria=c.idcategoria
INNER JOIN sucursal s ON a.idsucursal=s.idsucursal
ORDER BY idarticulo DESC

answered Sep 11, 2018 at 18:34

DanB

2,1121 gold badge14 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Problems with SQL query with multiple tables

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related