Products in Trash used on Bookings

select I.booking_no_v32 as [Booking #], 

       I.FirstDate as [Out Date], 

       I.RetnDate as [In Date], 

       I.product_code_v42 as [Product],

       m.descriptionV6 as [Description]

from tblitemtran I

left outer join tblinvmas m on m.product_code = i.product_code_v42

Where m.IsInTrashCan = 'Y'

order by i.FirstDate

select I.booking_no_v32 as [Booking #], 

       I.FirstDate as [Out Date], 

       I.RetnDate as [In Date], 

       I.product_code_v42 as [Product],

       m.descriptionV6 as [Description]

from tblHistitm I

left outer join tblinvmas m on m.product_code = i.product_code_v42

Where m.IsInTrashCan = 'Y'

order by i.FirstDate