在Where 语句中有2个列的SQL语句
万能的社区我在cache中创建一个视图时遇到了麻烦,其查询方式为:
SELECT column1, column2, column 3
FROM table
WHERE
(column1, columnn 2) IN (SELECT c1, c2 FROM table2 GROUP BY c1)
ORDER BY column1
我认为问题出在where子句上,因为它不能取两列: .
具体错误信息为: [SQLCODE: <-1>:<Invalid SQL statement>] [%msg: < ) expected, , found^ (column1,>]
请问如何解决? 谢谢!
答案参见英文社区:https://community.intersystems.com/post/sql-2-columns-where-condition#co...