How to make a query with join?

Bertha Gabriela Nuñez Fernandez

I did a join but it does not show me the fields of the two tables
only the fields of the first table
[join1.jpg]
[join2.jpg]

Michael Udinski

You could use Evals to add fields of another table if you wish to go that route:
(Output > Evals)
[Screenshot_2021-08-19_18-45-49.png]

Bertha Gabriela Nuñez Fernandez

Thanks, this solved my problem

Vince

By the way @Michael the Eval doesn't show an image's URL only path, name, type, size, but not it's specific url[CleanShot 2022-04-07 at 18.25.54.png]in the addon it does

Michael Udinski

 this is because the URL is not part of the stored metadata. Xano creates the URL on the fly for convenience. The URL is your Xano domain and path combined.