Как можно конкатенировать значения под запроса?

Question

[inilim2]

Что-то вроде:

SELECT
	CONCAT(SELECT idTag FROM tag_in_record WHERE idRecord = 7060) AS list,
	*
FROM records WHERE id = 7060

Answer 1

[Дмитрий]

SELECT
  (SELECT group_concat(idTag) FROM tag_in_record WHERE idRecord = 7060) AS list,
  *
FROM records WHERE id = 7060

только теоретически вам точно нуженподзапрос?

SELECT
  *,
  group_concat(idTag)  AS list
FROM records 
join tag_in_record on tag_in_record.idRecord = records.id 
WHERE id = 7060
group by records.fields

Comments

[inilim2]

Ну я его так впиндюрил:

SELECT
      r.*, u.*,
      (SELECT GROUP_CONCAT(idTag) FROM tag_in_record WHERE idRecord = :id) as listTags
      FROM records as r
      INNER JOIN users as u
      ON r.idUser = u.id AND r.id = :id