Nested database query

Hey there, I am a new Wappler user and I am having trouble creating a database query in API action.
what I want to do is I want to get the list of all countries where I have not visited, Both are different tables and I don’t know How can I give an output of one API action to another API action as a condition.

IE:
Select * from AllCountries where CountryName Not in (select CountryName from VisitedCountries)

I have tried using nested-repeated-regions but I could not get wanted results.