# Emblem.Carpet

# Querying docitems to see what services the customer bought

SELECT docitems.\*, items.title, services.title, item\_storage.barcode, item\_storage.quantity, item\_storage.shelf FROM `carpet-emblem`.docitems  
left join item\_storage on item\_storage.id = docitems.id\_item\_storage  
left join items on item\_storage.iditem = items.id  
left join item\_services on item\_services.id = docitems.id\_item\_service  
left join services on item\_services.idservice = services.id;