SQL subquery support?

Developer Talk
1

Hi everyone !
I didn’t manage to use SQL subqueries in Seatable, either using the SQL query plugin or with python scripts. If I write parenthesis, I get a parse error (unexpected “(” ), and if I don’t I get a parse error (unexpected select). Do you know how I can solve this problem ?
Thanks a lot !

2

Hi @bennhatton.

SeaTable has his “own” SQL Syntax. You can read the reference here: SQL Reference - SeaTable Programming Manual

3

Thank you for your answer, I saw this page before I posted the subject because there is no information about subqueries on it…

4

I think you are trying to connect two tables without a reference column and trying to get values on this way. That is not how it works, unfortunately.

I believe this is something SeaTable will not support. Your only chance is to create a reference column and manually select the referencing value from the other column. Then you can select the column from the other table.

5

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.