>>>>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.
>
>Ok. We agree to disagree :).
The simple way for you would be to test both versions and find out which one performs better.
If it's not broken, fix it until it is.
My Blog