>>Try
>>

>>select Eq.Equip_Id, Eq.Equip_Desc, Tr.*
>>
>>from Equipment Eq INNER JOIN TransDetail Tr on Eq.Equp_Pk = Tr.Equp_Pk
>>UNION -- this will make result distinct
>>select Eq.Equip_Id, Eq.Equip_Desc, Tr.*
>>from TransDetail Tr INNER JOIN Orders Or on Tr.Order_No = Or.Order_No
>>inner join Equipment Eq ON Or.Orders_Equip_ID = Eq.Equip_ID

>
>Thank you. Please see my reply Thomas if the SQL Select I have created also makes sense.

I think the UNION version is clearer and easier to understand. It is also more likely to perform better.