MUST SPECIFY TABLE TO SELECT FROM ,2 RECEIVED ALERTS COULD NOT BE PREPARED

[Former Member]

**Dear All, I get this Error"MUST SPECIFY TABLE TO SELECT FROM ,2 RECEIVED ALERTS COULD NOT BE PREPARED"** Please help me solve this

SELECT T1.AcctCode, T1.AcctName FROM OACT T1 WHERE (T1.AcctCode ='ACACBB0001' OR T1.AcctCode ='ACACBBBP01' OR T1.AcctCode ='ACACBBBP02' OR T1.AcctCode ='ACACBBBP03' OR T1.AcctCode ='ACACBBBP04' OR T1.AcctCode ='LLFSLCC001' OR T1.AcctCode ='LLFSLCC002' OR T1.AcctCode ='LLFSLTL001' OR T1.AcctCode ='LLFULFO001')

AND T1.AcctCode NOT IN (SELECT T0.Account FROM JDT1 T0 WHERE T0.REFDATE<='[%0]' AND (T0.Account ='ACACBB0001' OR T0.Account ='ACACBBBP01' OR T0.Account ='ACACBBBP02' OR T0.Account ='ACACBBBP03' OR T0.Account ='ACACBBBP04' OR T0.Account ='LLFSLCC001' OR T0.Account ='LLFSLCC002' OR T0.Account ='LLFSLTL001' OR T0.Account ='LLFULFO001' ) )

Regrds

MD Zubair

[Former Member · Accepted solution]

change the query as

declare @date datetime
SELECT @date =  T0.refdate FROM JDT1 T0 WHERE T0.REFDATE ='[%0]' 

SELECT T1.AcctCode, T1.AcctName FROM OACT T1 WHERE (T1.AcctCode ='ACACBB0001' OR T1.AcctCode ='ACACBBBP01' OR T1.AcctCode ='ACACBBBP02' OR T1.AcctCode ='ACACBBBP03' OR T1.AcctCode ='ACACBBBP04' OR T1.AcctCode ='LLFSLCC001' OR T1.AcctCode ='LLFSLCC002' OR T1.AcctCode ='LLFSLTL001' OR T1.AcctCode ='LLFULFO001') 
AND T1.AcctCode NOT IN (SELECT T0.Account FROM JDT1 T0 WHERE T0.REFDATE<=@date AND (T0.Account ='ACACBB0001' OR T0.Account ='ACACBBBP01' OR T0.Account ='ACACBBBP02' OR T0.Account ='ACACBBBP03' OR T0.Account ='ACACBBBP04' OR T0.Account ='LLFSLCC001' OR T0.Account ='LLFSLCC002' OR T0.Account ='LLFSLTL001' OR T0.Account ='LLFULFO001' ) )

[Former Member]

Thanks Peter