Hi everyone,
I need some help with formulating SQL queries in softr.io using data stored in Xano. I want to make sure that I'm using the correct table and schema names. I have a few tables defined in my database, including Specialization, SpecializationSkills, and Skill (under the name x3_151).
When I try to run SQL queries, Xano returns errors like "relation does not exist," which suggests there might be an issue with the table names. My question is: where exactly in Xano can I find the actual table and column names that I should be using in my SQL queries? Is there a tool in Xano that allows me to view the full table and schema names?
I'd appreciate any guidance or tips on how I can do this to ensure my queries work correctly in softr.io.
Thanks!