Is it possbile to query a view that link 2 data source by a link column?(relation query)

[doney88]

for example

1. in the [Projects] folder, I have all the project note in it.
2. In the [Tasks] folder, I have all the tasks note in it.
3. Each Task note has the metadata [Project], which saves the Project Note Link.

Can I query these 2 different types of notes' properties to show in the same row, based on the related metadata [Project]?
Just like normal SQL Clause " INNER JOIN "?

the result columns may be like the below:
Task Name (Task Property) | Task Due(Task Property) | Project Name(Project Property) | Project Due (Project Property)

[AB1908]

I also wish I could write joins but I personally tend to drop into JS to pull this off. Meanwhile, you can try some ideas like querying only the Tasks folder and then pulling in related properties like so: table taskname, project.due from "tasks". You can directly reference a field in another page if project is a wikilink.