I am trying to create a query report with the following query
select
tabGL Entry
.posting_date
,tabDynamic Link
.parent
,tabAddress
.name
,tabAddress
.address_line1
,tabAddress
.address_line2
from
tabGL Entry
,tabDynamic Link
,tabAddress
where
tabDynamic Link
.link_name = tabGL Entry
.party and
tabAddress
.name = tabDynamic Link
.parent and
tabDynamic Link
.link_doctype = “Supplier”
;
This works fine on the mysql console, but it displayes as the picture below when I run the report from ERPNext
I appreciate any feedback on why it wouldn’t display columns from multiple tables, even though the query does fetch the required records