列'Tabel1.Nama‘在select列表中无效,因为它既不包含在聚合函数中,也不包含在GROUP BY子句中。我有两张桌子,表1和表2我想表现得像这样我的问题是:Tabel1, Table2 WHERE Tabel1.NIK = Table2.NIK GROUP BY Tabel1.NIK
但是我有一个
(最后4个字符)`SELECT * FROM tabel LEFT JOIN tabel_fts on tabel_fts.domainObjectId = tabel.domainObjectIdWHERE tabel_fts MATCH '3210*' OR tabel.domainObjectId LIKE '%3210%'unable to use function