Select subqueries

[lordzardeck]

For some reason I can't get a subquery within a select statement. My objective is to take the subjects, and put them into one field. My query is below, and any help is appreciated!

 

SELECT
item.circulationtypeid,
item.itemid,
item.accessionnum,
item.lccn,
item.dewey,
item.author,
item.illustrator,
item.title,
item.responsibility,
item.edition,
item.pubplace,
item.publisher,
item.pubdate,
item.series,
item.seriesnum,
item.extent,
item.illustrations,
item.binding,
item.condition,
item.price,
item.source,
item.entrydate,
(select itemsubject.itemid, itemsubject.itemsubjectid, itemsubject.subjectid FROM itemsubject RIGHT OUTER JOIN subject ON itemsubject.subjectid = subject.subjectid WHERE itemsubject.itemid = item.itemid) as subjectcolumn
FROM
item

[fenway]

What error? What mysql version?

[lordzardeck]

I get the error:

 

1241 Operand should contain at least one column.

 

When i researched on the internet, I found out it has to do with the select query, but I can't figure out exactly what.

[lordzardeck]

Oh, and my server version is MySql 5

[fenway]

My guess is that you're returning more than a single row in that subquery.

[lordzardeck]

Yeah, that's intended. I wanted to take the returned fields, and combind them into one.

[fenway]

Yeah, that's intended. I wanted to take the returned fields, and combind them into one.

Well, a subquery in the field list can only return a *single* value -- and I don't see a CONCAT().

[lordzardeck]

how would you use concat for multiple rows in a subquery?

[fenway]

with Group_concat()... but I'm not sure what you're trying to accomplish.