Custom Query Report for Sales Invoice Details of Taxes and Charges

Hi, I’m just trying to create a simple query on both the Sales Invoice and Sales Taxes and Charges tables. here is my SQL:

SELECT si.name, si.posting_date, si.title, si.shipping_address, si.base_total, sc.description, sc.tax_amount, si.grand_total
FROM tabSales Invoice si INNER JOIN tabSales Taxes and Charges sc ON tabSales Invoice.name = tabSales Taxes and Charges.parent;

But when I run it, I don’t get any results. I thought i was doing something wrong, so I quickly just pulled both tables into MS Access and ran the same SQL and I got my results. Can someone assist?

For the custom query report, i put the DocType as Sales Invoice. Not sure that matters.

Thanks.

JR