Trying to join json api data to a postgres query

I have read a few examples of people joining data from different types of data sources. I tried it and I keep getting this error. What I am doing wrong?

Here are screenshots of the 2 different data sources.

Are you using a JSON SQL query? Only that type of resource can use a Retool data source as the table source.

If you are using the JSON SQL query this query looks like it should work, but try adding as to your aliases: {{}} as tc