olokedeomotayo commented on issue #4269: Adding new Query URL: https://github.com/apache/incubator-superset/issues/4269#issuecomment-359829143 Thank You once again. i would like you to take a look at the SQL Script below; SELECT name AS name, (`tabSales Invoice Item`.item_group) AS item_group, (`tabSales Invoice Item`.item_name) AS item_name, SUM(`tabSales Invoice Item`.amount) AS sum__amount (`tabSales Invoice Item'.customer_name) AS customer_name, SUM(`tabSales Invoice`.total) AS sum__total FROM (`tabSales Invoice Item`) LEFT JOIN `tabSales Invoice` ON `tabSales Invoice`.name = `tabSales Invoice Item`.name WHERE creation >= '2016-09-10 00:00:00' AND creation <= '2018-01-23 11:41:34' GROUP BY name, item_group, item_name, customer_name ORDER BY sum__amount DESC LIMIT 50000 the table is returning only for the first table ignoring the other table. Any Help Also
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services
