No, that's not the debug option you need to enable. The debug flag is located in the Server Connect options. That's already been explained in our docs:
Thanks, can you help me understand what this means
{"status":"500","code":"42883","message":"select * from \"transaction\" inner join \"user\" on \"user\".\"user_id\" = \"transaction\".\"user\" and \"user\".\"name\" = \"transaction\".\"user\" and \"user\".\"image\" = \"transaction\".\"user\" - operator does not exist: character varying = integer","stack":"error: select * from \"transaction\" inner join \"user\" on \"user\".\"user_id\" = \"transaction\".\"user\" and \"user\".\"name\" = \"transaction\".\"user\" and \"user\".\"image\" = \"transaction\".\"user\" - operator does not exist: character varying = integer\n at Parser.parseErrorMessage (/app/node_modules/pg-protocol/dist/parser.js:278:15)\n at Parser.handlePacket (/app/node_modules/pg-protocol/dist/parser.js:126:29)\n at Parser.parse (/app/node_modules/pg-protocol/dist/parser.js:39:38)\n at TLSSocket.<anonymous> (/app/node_modules/pg-protocol/dist/index.js:8:42)\n at TLSSocket.emit (events.js:314:20)\n at addChunk (_stream_readable.js:303:12)\n at readableAddChunk (_stream_readable.js:279:9)\n at TLSSocket.Readable.push (_stream_readable.js:218:10)\n at TLSWrap.onStreamRead (internal/stream_base_commons.js:188:23)"}
{"status":"500","code":"42883","message":"select * from \"transaction\" inner join \"user\" on \"user\".\"user_id\" = \"transaction\".\"user\" and \"user\".\"name\" = \"transaction\".\"user\" and \"user\".\"bitmoji\" = \"transaction\".\"user\" - operator does not exist: character varying = integer","stack":"error: select * from \"transaction\" inner join \"user\" on \"user\".\"user_id\" = \"transaction\".\"user\" and \"user\".\"name\" = \"transaction\".\"user\" and \"user\".\"bitmoji\" = \"transaction\".\"user\" - operator does not exist: character varying = integer\n at Parser.parseErrorMessage (/app/node_modules/pg-protocol/dist/parser.js:278:15)\n at Parser.handlePacket (/app/node_modules/pg-protocol/dist/parser.js:126:29)\n at Parser.parse (/app/node_modules/pg-protocol/dist/parser.js:39:38)\n at TLSSocket.<anonymous> (/app/node_modules/pg-protocol/dist/index.js:8:42)\n at TLSSocket.emit (events.js:314:20)\n at addChunk (_stream_readable.js:303:12)\n at readableAddChunk (_stream_readable.js:279:9)\n at TLSSocket.Readable.push (_stream_readable.js:218:10)\n at TLSWrap.onStreamRead (internal/stream_base_commons.js:188:23)"}
But that’s totally wrong. You can’t just add all the fields like that and not even select a column for the other table.
Are you sure you know what a db table join is, how it is used and when?
But what are you trying to achieve? Why do you want to use a join?
There are literally thousands of resources regarding sql joins in the internet so if you don’t know what/how/when to use, I suggest you to check this: https://www.w3schools.com/sql/sql_join.asp
Please check the resource I linked to to understand how sql joins work.
Then go back to the join dialog, select the proper join per your needs and select the two columns in your both tables you need to join.