Unanswered: ODBC-Call Failed Syntax Error near 'Join'
All of sudden this sql statement is not working. Pls look this over and see how this can be fixed. Thanks so much for any help
Member.membernumber AS id,
MemValley.ValleySeq AS HomeValley,
CASE MemValley.MemValleyStatusID WHEN 1 THEN 'F' ELSE 'T' END as Inactive
INNER JOIN MemValley on Member.MemberNumber = MemValley.MemberNumber
INNER JOIN v_MemCurrentAddress ON Member.MemberNumber = v_MemCurrentAddress.MemberNumber
COUNT(*) AS ct_sol,
) AS ct_mem_sol ON Member.MemberNumber = ct_mem_sol.MemberNumber
(Member.MemberStatusID = 1 and MemValley.MemValleyDegree14StatusID = 10) -- pick out HV
OR (Member.MemberStatusID = 3 and MemValley.MemValleyDegree14StatusID = 20) --
AND MemValley.ValleySeq not like 'MA9%'
-- AND Member.MemberNumber='100000148'