Inventory Transfer with bin Locations

Hi guys,

I am trying to create a layout in crystal reports for an inventory transfer and need to reference FROM BIN and TO BIN.

at the moment i am joining like this

select * from OWTR inner join WTR1 on OWTR.DocEntry = WTR1.DocEntry

left outer join OILM on WTR1.LineNum = OILM.DocLineNum

left outer join OBTL on OILM.MessageID = OBTL.MessageID

left outer join OBIN on OBTL.BinAbs = OBIN.AbsEntry

where OILM.transtype = 67

has anyone done this sort of layout before?