﻿SELECT detstock.id, detstock.item, detstock.Mainitem, detstock.description, detstock.qty, detstock.WareHouse, detstock.ItemType, detstock.Branch, stock.pricea, stock.priceb, stock.Categorya, stock.Categoryb, stock.Categoryc, stock.Categoryd, stock.DESCRIPTION2, stock.StockA, stock.StockB, stock.StockC, stock.CostUs FROM detstock LEFT JOIN stock ON stock.item = detstock.item WHERE TRIM(CONVERT(detstock.Warehouse USING utf8mb4)) COLLATE utf8mb4_unicode_ci = TRIM(CONVERT('الصالة' USING utf8mb4)) COLLATE utf8mb4_unicode_ci 
