Query Report from Two Doctypes

ERPNext Reports
1

I am trying to make a query report that will show all tasks within multiple projects that share the same tag, or project type value. Any ideas how to achieve this? I am not so good with SQL.

2

yes it’s really simple to use it
you can try :

SELECT i.name , p.name
FROM TableName i
Inner Join TableName p
On i.name = p.name
#you can change the relation

2 Likes