This topic has been archived. It cannot be replied.
-
工作学习 / 学科技术讨论 / 请教Firebird SQL 语句SELECT a.* , b.* from a
LEFT JOIN
(
SELECT * FROM c
WHERE ...
) AS b
ON b.id = a.Id
上边的语句在MS-SQL SERVER 通过测试， FIREBIRD 出现语法错误
感觉是FIREBIRD 不支持JOIN 临时表。
现在想把它改写为FIREBIRD SQL 语句，不知道如何写。
-bobo123(以马内利);
2008-1-29
{243}
(#4224262@0)
-
如果你的子查询没有复杂变换（比如GROUP BY什么的）可以把WHERE移出来SELECT a.* , c.* from a
LEFT JOIN c
ON a.id = c.id
WHERE ....
-newkid(newkid);
2008-1-29
{65}
(#4224312@0)
-
It's not temp table. It's called subquery. If it doen't support subquery, you can try temp table.
-deep_blue(BLUE);
2008-1-29
(#4224443@0)
-
try 2 use 'left outer join'
-registereduser(立牌坊);
2008-2-13
(#4260487@0)