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.
Anyone got any ideas?Code: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



Reply With Quote