select **
** [ShipHead].[ShipDate] as [ShipHead_ShipDate],
** [ShipHead].[PackNum] as [ShipHead_PackNum],**
** [ShipTo].[INVATNumber] as [ShipTo_INVATNumber],**
** [ShipHead].[TotalDiscount] as [ShipHead_TotalDiscount],**
** [ShipHead].[OrderAmt] as [ShipHead_OrderAmt],**
** [ShipHead].[ShipToNum] as [ShipHead_ShipToNum],**
** [ShipHead].[CustNum] as [ShipHead_CustNum],**
** [ShipHead].[Plant] as [ShipHead_Plant],**
** [ShipHead].[BTCustNum] as [ShipHead_BTCustNum],**
** [ShipHead].[BTConNum] as [ShipHead_BTConNum],**
** [ShipHead].[NotifyEMail] as [ShipHead_NotifyEMail],**
** [ShipHead].[CertOfOrigin] as [ShipHead_CertOfOrigin],**
** [ShipHead].[HazardousShipment] as [ShipHead_HazardousShipment],**
** [ShipHead].[IntrntlShip] as [ShipHead_IntrntlShip],**
** [ShipHead].[CurrencyCode] as [ShipHead_CurrencyCode],**
** [ShipHead].[TotalWHTax] as [ShipHead_TotalWHTax],**
** [ShipHead].[DocTotalWHTax] as [ShipHead_DocTotalWHTax],**
** [ShipHead].[TotalSATax] as [ShipHead_TotalSATax],**
** [ShipHead].[DocTotalSATax] as [ShipHead_DocTotalSATax],**
** [ShipHead].[TotalTax] as [ShipHead_TotalTax],**
** [ShipHead].[DocTotalTax] as [ShipHead_DocTotalTax],**
** [ShipHead].[DocTotalDiscount] as [ShipHead_DocTotalDiscount],**
** [ShipHead].[ShipToCustNum] as [ShipHead_ShipToCustNum],**
** [ShipTo].[CustNum] as [ShipTo_CustNum],**
** [ShipTo].[ShipToNum] as [ShipTo_ShipToNum],**
** [ShipTo].[Name] as [ShipTo_Name],**
** [ShipTo].[Address1] as [ShipTo_Address1],**
** [ShipTo].[Address2] as [ShipTo_Address2],**
** [ShipTo].[Address3] as [ShipTo_Address3],**
** [ShipTo].[City] as [ShipTo_City],**
** [ShipTo].[State] as [ShipTo_State],**
** [ShipTo].[ZIP] as [ShipTo_ZIP],**
** [ShipTo].[Country] as [ShipTo_Country],**
** [ShipTo].[SalesRepCode] as [ShipTo_SalesRepCode],**
** [ShipTo].[TerritoryID] as [ShipTo_TerritoryID],**
** [ShipTo].[ShipViaCode] as [ShipTo_ShipViaCode],**
** [ShipTo].[FaxNum] as [ShipTo_FaxNum],**
** [ShipTo].[PhoneNum] as [ShipTo_PhoneNum],**
** [ShipTo].[EMailAddress] as [ShipTo_EMailAddress],**
** [ShipTo].[TerritorySelect] as [ShipTo_TerritorySelect],**
** [ShipTo].[ChrgAmount] as [ShipTo_ChrgAmount],**
** [ShipTo].[NotifyEMail] as [ShipTo_NotifyEMail],**
** [ShipTo].[DeclaredIns] as [ShipTo_DeclaredIns],**
** [ShipTo].[DeclaredAmt] as [ShipTo_DeclaredAmt],**
** [Customer].[Company] as [Customer_Company],**
** [Customer].[CustID] as [Customer_CustID],**
** [Customer].[CustNum] as [Customer_CustNum],**
** [Customer].[Name] as [Customer_Name],**
** [Customer].[Address1] as [Customer_Address1],**
** [Customer].[Address2] as [Customer_Address2],**
** [Customer].[Address3] as [Customer_Address3],**
** [Customer].[City] as [Customer_City],**
** [Customer].[State] as [Customer_State],**
** [Customer].[Zip] as [Customer_Zip],**
** [Customer].[Country] as [Customer_Country],**
** [Customer].[SalesRepCode] as [Customer_SalesRepCode],**
** [Customer].[TerritoryID] as [Customer_TerritoryID],**
** [Customer].[ShipToNum] as [Customer_ShipToNum],**
** [Customer].[ShipViaCode] as [Customer_ShipViaCode],**
** [Customer].[PhoneNum] as [Customer_PhoneNum],**
** [Customer].[CurrencyCode] as [Customer_CurrencyCode],**
** [Customer].[CountryNum] as [Customer_CountryNum],**
** [Customer].[BTName] as [Customer_BTName],**
** [Customer].[BTAddress1] as [Customer_BTAddress1],**
** [Customer].[BTAddress2] as [Customer_BTAddress2],**
** [Customer].[BTAddress3] as [Customer_BTAddress3],**
** [Customer].[BTCity] as [Customer_BTCity],**
** [Customer].[BTState] as [Customer_BTState],**
** [Customer].[BTZip] as [Customer_BTZip],**
** [Customer].[BTCountryNum] as [Customer_BTCountryNum],**
** [Customer].[BTCountry] as [Customer_BTCountry],**
** [Customer].[BTPhoneNum] as [Customer_BTPhoneNum],**
** [Customer].[ParentCustNum] as [Customer_ParentCustNum],**
** [Customer].[EMailAddress] as [Customer_EMailAddress],**
** [Company].[Company] as [Company_Company],**
** [Company].[Name] as [Company_Name],**
** [Company].[Address1] as [Company_Address1],**
** [Company].[Address2] as [Company_Address2],**
** [Company].[Address3] as [Company_Address3],**
** [Company].[City] as [Company_City],**
** [Company].[State] as [Company_State],**
** [Company].[Zip] as [Company_Zip],**
** [Company].[Country] as [Company_Country],**
** [Company].[PhoneNum] as [Company_PhoneNum],**
** [Company].[CountryNum] as [Company_CountryNum],**
** [Company].[LegalName] as [Company_LegalName],**
** [ShipDtl].[PackLine] as [ShipDtl_PackLine],**
** [ShipDtl].[PartNum] as [ShipDtl_PartNum],**
** [ShipDtl].[LineDesc] as [ShipDtl_LineDesc],**
** [ShipDtl].[WarehouseCode] as [ShipDtl_WarehouseCode],**
** [OrderHed].[OrderNum] as [OrderHed_OrderNum],**
** [Part].[NetWeight] as [Part_NetWeight],**
** [Part].[GrossWeight] as [Part_GrossWeight],**
** [PartCOO].[OrigCountry] as [PartCOO_OrigCountry],**
** [ShipDtl].[UnitPrice] as [ShipDtl_UnitPrice],**
** [ShipDtl].[SellingInventoryShipQty] as [ShipDtl_SellingInventoryShipQty],**
** [ShipDtl].[SellingJobShipQty] as [ShipDtl_SellingJobShipQty],**
** (ShipDtl.SellingInventoryShipQty + ShipDtl.SellingJobShipQty) as [Calculated_TotalShipQty],**
** [Country].[Description] as [Country_Description],**
** [SalesRep].[Name] as [SalesRep_Name],**
** [Part].[CommodityCode] as [Part_CommodityCode],**
** [ShipDtl].[ExtPrice] as [ShipDtl_ExtPrice]**
from Erp.ShipHead as ShipHead
inner join Erp.ShipTo as ShipTo on **
** ShipHead.Company = ShipTo.Company
** and ShipHead.CustNum = ShipTo.CustNum**
** and ShipHead.ShipToNum = ShipTo.ShipToNum**
inner join Erp.Customer as Customer on **
** ShipTo.Company = Customer.Company
** and ShipTo.CustNum = Customer.CustNum**
left outer join Erp.SalesRep as SalesRep on **
** SalesRep.Company = Customer.Company
** and SalesRep.SalesRepCode = Customer.SalesRepCode**
inner join Erp.Company as Company on **
** ShipHead.Company = Company.Company
inner join Erp.ShipDtl as ShipDtl on **
** ShipHead.Company = ShipDtl.Company
** and ShipHead.PackNum = ShipDtl.PackNum**
inner join Erp.Part as Part on **
** ShipDtl.Company = Part.Company
** and ShipDtl.PartNum = Part.PartNum**
inner join Erp.PartCOO as PartCOO on **
** Part.Company = PartCOO.Company
** and Part.PartNum = PartCOO.PartNum**
inner join Erp.Country as Country on **
** PartCOO.Company = Country.Company
** and PartCOO.OrigCountry = Country.CountryNum**
left outer join Erp.OrderDtl as OrderDtl on **
** ShipDtl.Company = OrderDtl.Company
** and ShipDtl.OrderNum = OrderDtl.OrderNum**
** and ShipDtl.OrderLine = OrderDtl.OrderLine**
inner join Erp.OrderHed as OrderHed on **
** ShipHead.Company = OrderHed.Company
** and ShipHead.OTSOrderNum = OrderHed.OrderNum**
emphasized text
Not sure which one is more helpful.
