Business Objects Joins

[InvisibleDuncan]

Anyone know how to do nested joins in Business Objects? I've got this join in a SQL Server stored procedure, and I want to repeat it in Business Objects. It's not instantly obvious how I should do it, though. :(


From tblParcel P
Left Join (tblParcelShipToShip stsMaster
Inner Join tblcPorts stsMasterPort On stsMasterPort.PortID = stsMaster.TransferAreaID
Left Join tblAddresses stsMasterSup On stsMasterSup.ADID = stsMaster.SuperintendentID
) On stsMaster.ParcelID = P.ParcelID
Left Join (tblParcelShipToShip stsChild
Inner Join tblParcel stsChildParcel On stsChildParcel.ParcelID = stsChild.ParcelID
Inner Join tblVoyage stsChildVoyage On stsChildVoyage.VoyageID = stsChildParcel.VoyageID
Inner Join tblVessel stsChildVessel On stsChildVessel.VesselID = stsChildVoyage.VesselID
Inner Join tblcPorts stsChildPort On stsChildPort.PortID = stsChild.TransferAreaID
Left Join tblAddresses stsChildSup On stsChildSup.ADID = stsChild.SuperintendentID
) On stsChild.Linkeds2sParcelID = P.ParcelID


Anyone got any ideas?