can we feed the results from the first query (learners) into the second query (lessons)

[Anonymous]

I have two tables learner and lessons. I am applying all the where clauses in the lessons table which I am already applying in the learners table for learners. My issue is that I don;t want the result from first query and pass that in the second query to get the results. So for example I have learner data like 

Select * from learners l where l.status = 'Active' 

Select * from lessons_log ll where ll.learnerid = :l.learnerid 

How can I call that second query in power bi based on the learner id from learners table 

[v-jingzhan-msft]

Hi @Anonymous 

You may try this for the second query:

SELECT ll.*
FROM learners l
JOIN lessons_log ll
ON l.learnerid = ll.learnerid
WHERE l.status = 'Active'

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

[Anonymous]

I don't want a join that is the whole point. I want the learner id's from first query

to be passed into the second query ll.learnerId

[v-jingzhan-msft]

Hi @Anonymous 

If you don't want a join in the sql statement, you may first connect to the lessons_log table without any filtering or joining, then use the merge queries feature in Power Query. 

Merge queries overview - Power Query

Inner join - Power Query

Best Regards,
Jing