MySQL Forums
Forum List  »  General

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.

Options: ReplyQuote


Subject
Written By
Posted
Re: #1241 - Operand should contain 1 column(s)
March 13, 2012 09:27AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.