Задавайте вопросы, мы ответим
Вы не зашли.
Как исправить?
SELECT
sct.RECID,
sct.TID,
sct.CONTACTDATE,
sct.STATUS,
sct.CONTACTTIME,
ct.NAME,
sct.CONTENT,
convert(text, sct.USERMEMO) AS USERMEMO,
sct.CONTACTPERSONNAME,
sct.TYPE,
et.NAME AS EMPLNAME,
ct.ACCOUNTNUM
FROM
_0_ sct (nolock)
JOIN dbo.empltable et (nolock)
ON et.EMPLID = sct.EMPLID AND et.DATAAREAID = 'spr'
JOIN dbo.custtable ct (nolock)
ON ct.ACCOUNTNUM = sct.CUSTACCOUNT AND ct.DATAAREAID = 'krf'
WHERE
sct.DATAAREAID = 'krf'
AND et.EMPLID IN 'tal03'
ORDER BY
sct.CONTACTDATE
Неактивен