Forum Discussion
Error Query SQL multiple select
Hello everyone I have a problem with the following query SELECT (SELECT Dato FROM Dato_Medidor WHERE Linea = 'ELFO_006_Oficinas') as 'ELFO_006',
(SELECT Dato FROM Dato_Medidor WHERE Linea = 'ELFO_...
> Subquery returned more than 1 value.
As the error message clearly says. You have to take care that the sub-queries returns only & exact one row. Your filter is may not the right one; exactly I miss a referenc to the current row of table "Dato_Medidor", that can't be right.