Devam Ediyor

518600 mysql problem subqueries

Can someone pls tell me how do i select multiple values for "artist_names" column, when i run following query it says "#1242 - Subquery returns more than 1 row" but i want to select all artist names for that event, (since one event can have multiple artists)

++++++++++++++++++++++++++++++++++++++++++++++++++++++

SELECT e.event_id,

(SELECT a.artist_name FROM event_artist ea, artist a WHERE ea.artist_id=a.artist_id) AS artist_names,

e.event_name, e.event_intro, e.event_des,e.event_contact_name, e.event_contact, e.event_email, e.event_tags,

e.event_rating, e.event_rating_count, e.event_type, s.show_date_from, s.show_date_to , s.show_repeat,v.venue_id, v.venue_name, m.media_name, c.category_name,

IFNULL(img.image_thumb,'[url removed, login to view]') AS image_thumb

FROM event e

LEFT JOIN `show` AS s ON ( e.event_id = s.event_id )

LEFT JOIN `venue` AS v ON ( s.venue_id = v.venue_id )

LEFT JOIN `category` AS c ON ( e.category_id = c.category_id )

LEFT JOIN `media` AS m ON ( c.media_id = m.media_id )

LEFT JOIN `link_image` AS img ON ( e.event_id = img.event_id )

WHERE img.image_main='Y'

AND e.status='Y'

AND s.status='Y'

AND e.status='Y'

AND v.status='Y'

AND e.status='Y'

AND m.status='Y'

AND c.status='Y'

AND img.status='Y'

GROUP BY e.event_id

Beceriler: Her şey Kabul, MySQL

Daha fazlasını görün: want artists event, artist names, mysql status, media query, mysql join, artists names, mysql problem, mysql column row, problem category, mysql left, show mysql query, show ea, mysql row, mysql multiple select, mysql run query, select query event, mysql category, query mysql, values mysql, mysql run, mysql event

İşveren Hakkında:
( 63 değerlendirme ) Sydney, Australia

Proje NO: #2264534