Please help with SQL

User Talk Plugins
1

I need help. I’m trying to fill a table with data from another table, but when I execute the SQL statement, nothing happens. Could you help me formulate the correct SQL clause? Right now, I’m getting the following error: “parse error: unexpected SELECT near Saldo_d”. Below is the statement I’m working on:

INSERT INTO Saldos (Copro, Pro, Fecha, Saldo_d)
SELECT Copropietario, Propiedad, Fecha_pago, Saldo
FROM Control
WHERE MONTH(Fecha_pago) = 12 AND YEAR(Fecha_pago) = 2024 AND Saldo > 0

Thank you in advance for your help!

2

SeaTable has an SQL-like endpoint, but not everything that is possible with mariadb or mysql will also work in SeaTable. Therefore, I would assume, that this combination of Insert and select is not supported.

Here is a summary of what is currently supported: SQL Reference - SeaTable Developer Manual

Probably @daniel.pan can correct me if I am wrong…

1 Like
3

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