SELECT     dbo.PLMAIN.PACKLISTNO, dbo.SHIPBILL.SHIPTO, dbo.SHIPBILL.ADDRESS1, dbo.SHIPBILL.ADDRESS2, dbo.SHIPBILL.CITY, dbo.SHIPBILL.STATE,

                      dbo.SHIPBILL.ZIP, dbo.CCONTACT.LASTNAME, dbo.CCONTACT.FIRSTNAME, dbo.SHIPBILL.SHIPVIA, dbo.SHIPBILL.E_MAIL, dbo.SOMAIN.SONO,

                      dbo.SOMAIN.PONO, dbo.INVENTOR.PART_NO, dbo.INVENTOR.REVISION

FROM         dbo.CCONTACT RIGHT OUTER JOIN

                      dbo.PLMAIN INNER JOIN

                      dbo.PLDETAIL ON dbo.PLMAIN.PACKLISTNO = dbo.PLDETAIL.PACKLISTNO ON dbo.CCONTACT.CID = dbo.PLMAIN.ATTENTION LEFT OUTER JOIN

                      dbo.INVENTOR LEFT OUTER JOIN

                      dbo.SODETAIL ON dbo.INVENTOR.UNIQ_KEY = dbo.SODETAIL.UNIQ_KEY ON dbo.PLDETAIL.UNIQUELN = dbo.SODETAIL.UNIQUELN LEFT OUTER JOIN

                      dbo.SOMAIN ON dbo.PLMAIN.SONO = dbo.SOMAIN.SONO LEFT OUTER JOIN

                      dbo.SHIPBILL ON dbo.PLMAIN.LINKADD = dbo.SHIPBILL.LINKADD