Hi, can't figure out why I can't make a simple query.
let a = squel.select({ separator: '\n' })
.from("dbo.Person", "p")
.field("count(distinct p.personId)")
.left_join("dbo.OrganizationDetail", "od", "od.OrganizationUniqueID = p.OrganizationUniqueID")
.toString()
Output:
SELECT
count(distinct p.personId)
FROM dbo.Person `p`
LEFT JOIN dbo.OrganizationDetail `od` ON (od.OrganizationUniqueID = p.OrganizationUniqueID)
Error: RequestError: Incorrect syntax near '`'.
I see that the problem is under '`' sign, but why it formed like this? Could I somehow avoid these cross quotes?
Hi, can't figure out why I can't make a simple query.
Output:
Error: RequestError: Incorrect syntax near '`'.
I see that the problem is under '`' sign, but why it formed like this? Could I somehow avoid these cross quotes?