I have a crystal report that is pulling data from our posted AR_InvoiceHistoryHeader and AR_InvoiceHistoryDetail files and I have the exact same report pulling data from our un-posted SO_InvoiceHeader and SO_InvoiceDetail tables.  I want to have the two reports summarized into one that totals the quantity of Items ordered by Item Code and then have the report sort in Item Number order.  Below is the SQL statement for the first report:

 SELECT "CI_Item"."ProductLine", "SY0_CompanyParameters"."CompanyName", "CI_Item"."DefaultWarehouseCode", "CI_Item"."ProcurementType", "AR_InvoiceHistoryDetail"."ItemCode", "AR_InvoiceHistoryDetail"."WarehouseCode", "AR_InvoiceHistoryHeader"."UDF_SO_BATCH_NO", "AR_InvoiceHistoryDetail"."QuantityOrdered", "AR_InvoiceHistoryDetail"."UnitOfMeasure", "AR_InvoiceHistoryDetail"."ItemCodeDesc", "AR_InvoiceHistoryDetail"."DropShip", "AR_InvoiceHistoryDetail"."Valuation", "AR_InvoiceHistoryDetail"."ProductLine", "AR_InvoiceHistoryHeader"."InvoiceDate", "AR_InvoiceHistoryHeader"."InvoiceNo", "AR_InvoiceHistoryHeader"."SalespersonNo"  FROM   "AR_InvoiceHistoryHeader" "AR_InvoiceHistoryHeader", "AR_InvoiceHistoryDetail" "AR_InvoiceHistoryDetail", "SY0_CompanyParameters" "SY0_CompanyParameters", "CI_Item" "CI_Item"  WHERE  (("AR_InvoiceHistoryHeader"."InvoiceNo"="AR_InvoiceHistoryDetail"."InvoiceNo") AND ("AR_InvoiceHistoryHeader"."HeaderSeqNo"="AR_InvoiceHistoryDetail"."HeaderSeqNo")) AND ("AR_InvoiceHistoryHeader"."InvoiceType"<>"SY0_CompanyParameters"."CompanyName") AND (("AR_InvoiceHistoryDetail"."ItemCode"="CI_Item"."ItemCode") AND ("AR_InvoiceHistoryDetail"."ItemType"="CI_Item"."ItemType")) AND "AR_InvoiceHistoryDetail"."WarehouseCode"='013' AND ("AR_InvoiceHistoryHeader"."UDF_SO_BATCH_NO"='09956' OR "AR_InvoiceHistoryHeader"."UDF_SO_BATCH_NO"='10010') AND "AR_InvoiceHistoryDetail"."ItemCode"<>'120-BFO' AND "AR_InvoiceHistoryHeader"."InvoiceDate">={d '2014-04-13'} AND "AR_InvoiceHistoryDetail"."ProductLine"<>'ZP'  ORDER BY "SY0_CompanyParameters"."CompanyName"

I have attached a copy of what I have so far but don't quite know where to go from here to have the data pulled from both tables and then summarized because the field names for item code in both tables are completely different.

Any help would be greatly appreciated.