SQLize Online / PHPize Online  /  SQLtest Online

create TABLE items( id int PRIMARY KEY, name VARCHAR(255) ); insert into items values (1, 'Margarita'); create TABLE images ( id int PRIMARY KEY, img VARCHAR(255) ); insert into images values (1, 'pizza.jpg'), (2, 'big-pizza.jpg'); create TABLE item_images( item_id int, image_id int ); insert into item_images values (1, 1), (1, 2); select items.id, items.name, group_concat(img) images from items join item_images on items.id = item_images.item_id join images on images.id = item_images.image_id group by items.id, items.name;