我有以下查询,在MS Access、MySQL和SQL Server中运行良好,但当我尝试在SQLite中使用它时,我遇到了一个错误:
接近"(":语法错误:
我在SQLite的任何文档中都找不到Left命令,所以我想它不在那里,但我怎么能让它工作呢。
SELECT
Left(fldcall, 3) AS Group1,
Mid(fldcall, 4, 1) AS Group2,
tblcalls.*,
tblzip.fldcity
FROM
tblcalls
LEFT JOIN
tblzip ON tblcalls.fldzipcode = tblzip.fldzipcode;
您可以使用substr()函数:
SELECT substr(fldcall, 1, 3) AS Group1,
substr(fldcall, 4, 1) AS Group2,
tblcalls.*,
tblzip.fldcity
FROM tblcalls
LEFT JOIN tblzip USING (fldzipcode);