Re: #1241 - Operand should contain 1 column(s)
Posted by:
Mr Cue
Date: March 13, 2012 09:27AM
I've just realized that there wasn't anything that relates the two queries, for example, a common key, in this case both, Registro and Libro got a idLibro key. The final result is as follows:
SELECT Libro.idLibro, Libro.Libro, Libro.Subtitulo, Libro.Volumen,
Libro.Detalles, Periodicidad.Periodicidad, Genero.Genero,
Objeto_Editorial.Objeto_Editorial, Opcion.Opcion AS Inedito,
Detalle_Subcomite.*
FROM Libro
INNER JOIN Periodicidad ON
Periodicidad.idPeriodicidad=Libro.idPeriodicidad
INNER JOIN Genero ON Genero.idGenero=Libro.idGenero
INNER JOIN Objeto_Editorial ON
Objeto_Editorial.idObjeto_Editorial=Libro.idObjeto_Editorial
INNER JOIN Opcion ON Opcion.idOpcion=Libro.idOpcion
JOIN
(SELECT Registro.idLibro, Opcion.Opcion, Original.Original,
Directorio.Directorio AS Registrante, Organismo.Organismo,
Unidad.Unidad, Registro.Ingreso, Registro.Observaciones
FROM Registro
INNER JOIN Opcion ON Opcion.idOpcion=Registro.Protocolo
INNER JOIN Original ON Original.idOriginal=Registro.idOriginal
INNER JOIN Directorio ON Directorio.idDirectorio=Registro.Registrante
INNER JOIN Organismo ON Organismo.idOrganismo=Registro.idOrganismo
INNER JOIN Unidad ON Unidad.idUnidad=Registro.idUnidad) AS
Detalle_Subcomite
WHERE Detalle_Subcomite.idLibro=Libro.idLibro
ORDER BY Libro ASC
I added this line "WHERE Detalle_Subcomite.idLibro=Libro.idLibro".
Thanks! Hope it helps to someone too.
Edited 1 time(s). Last edit at 03/13/2012 10:28AM by Mr Cue.