use
distinct
select DISTINCT mt.MachinaryType, md.MachinaryName, md.Model, md.CountryOrRegion, md.WarrentyPeriod, md.PriceBDT,
d. DeptName, c.CompanyName, mp.MaintencePlanType, em.EmpCode, em.EmpName
from tblMachinaryDetails md
inner join tblMachinaryType mt on md.MTCode=mt.MTCode
inner join tblCompanyWiseMachine cm on cm.CMCode=md.CMCode
inner join tblDepartment d on d.DeptCode=cm.DeptCode
inner join tblCompany c on c.CompanyCode=cm.CompanyCode
inner join tblMaintencePlanEntry mp on mp.MDCode=md.MDCode
inner join tblDailyMaintenceDetails dm on dm.MDCode=md.MDCode
inner join tblEmployeeInformation em on em.EmpCode=dm.EmpCode
where md.MDCode='MDP-000001'
Happy Coding!
:)