Select DISTINCT
(a.Assets_ID),
   a.Offices_OfficesID,
   a.AssetInformation_AssetInformationID,
   a.Serial,
   a.AddQuantity,
   a.MEI,
   a.ICCID,
   a.AssetStatus,
   b.AssetType,
   c.Category,
   d.AssetCategories_AssetCategoriesName,
   m.ManufacturerName,
   x.Vehicle_ID,
   x.Emp_Id,
   x.Phone,
   x.QuantityforIssue as qty,
   x.AssignedStatus,
   x.AssignmentDate as stat_date,
   d.AssetCategories_AssetCategoriesName as asst_name,
   u.FirstName,
   u.LastName
FROM
   Assets as a
   JOIN
      AssetInformation as b
      ON a.AssetInformation_AssetInformationID = b.AssetInformation_ID
   JOIN
      AssetCategories as c
      ON c.AssetCategories_ID = b.Category
   JOIN
      AssetStatus as d
      ON d.AssetStatus_ID = a.AssetStatus
   JOIN
      Manufacturer as m
      ON m.Manufacturer_ID = a.Manufacturer
   JOIN
      AssetAssignment as x
      ON (x.Asset_ID = a.Assets_ID
      AND a.Offices_OfficesID = x.Offices_OfficesID)
   JOIN
      Users as u
      ON (u.UserID = x.Emp_Id
      or x.Emp_Id = 0)
WHERE
   a.Offices_OfficesID IN
   (
      1
   )