Dataview Queries Inside of Dataview Queries for Automation

What I’m trying to do

I’m creating travel notes so that I can keep track of my boss’s schedule. Every travel instance is it’s own note, and then I have the property “outgoing-flight”, where the value is a link to a note about that flight. Then, inside of that flight note, I have properties such as “departure-time” and “arrival-time.”

What I’m trying to do is make an itinerary for the entire trip without having to manually type this information, so that I only have to change it in one place. To do this, I’m trying to make a template that grabs this info automatically.

So, what I want the output to be is:
“6:00am [[Flight to Nashville]]”

Where the “6:00am” was taken from [[Flight to Nashville]]'s value for “departure-time”, and [[Flight to Nashville]] was taken from the current note’s property “outgoing-flight”. So basically, I think what I’m looking for is a way to write “a query within a query.”

Things I have tried

Option 1
input:

`=`=this.outgoing-flight`.departure-time` `=this.outgoing-flight`

output
==this.outgoing-flight.departure-time =this.outgoing-flight

Option 2
input

`=[[Flight to Nashville]].departure-time` `=this.outgoing-flight` 

output
I mean, this works obviously, but the goal is to not have to type in the name of the file.

I’m not familiar with coding outside of HTML basically. Although I am attempting to learn js, I’m not really understanding anything (I’m ADHD and Autistic so I have a hard time remembering new information) and I don’t understand anything about using js in obsidian.