SELECT
a.id,
(
SELECT
width
FROM
photos
WHERE
(user_id = a.id)
),
(
SELECT
height
FROM
photos
WHERE
(user_id = a.id)
),
a.name
FROM
table a
ERROR 1241 (21000): Operand should contain 1 column(s)
Weiss jemand wie man width und height in das Main-Select übernehmen kann?
Oder:
SELECT
a.id,
width,
height,
a.name
FROM
table a,
user
WHERE
(a.id = user.user_id)
;)