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
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.