Delivery information

Hello,

I need both open and closed orders and information from the following tables . How can I do the correct join between these tables.

SELECT DISTINCT dbo.ODLN.DocNum AS Del_No, convert(char(11),ODLN.[DocDate],110) as CreationDate,dbo.DLN1.ItemCode,DLN1.[Dscription] ,RDR1.[U_Per] as Personalize,

OITM.[U_LegacyItem] as LegacyItem,ORDR.[NumAtCard],CAST(RDR1.Text as nvarchar(max)) as PackageID, ODLN.TrackNo,CAST(ORDR.Comments as nvarchar(Max))as Remarks

FROM

Thanks

Max N