Hello,

I'm trying to building a custom container using the SAGE Intelligence Reporting Connector.  I would like the information in both the AP_InvoiceHeader and AP_InvoiceHistoryDetail table to draw from.  When run the following query with any polarity variation it tells me there's no data:

INNER JOIN "AP_InvoiceHeader"
ON "AP_InvoiceHeader"."InvoiceNo" = "AP_InvoiceHistoryDetail"."InvoiceNo")

I tried using Vendor number, APDivisionNo, and Vendor No.  

Any suggestions?

Thanks,

Joe