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;
No comments to display
No comments to display