Home » Developer & Programmer » Reports & Discoverer » Error in Query
Error in Query [message #89727] Sat, 10 July 2004 20:42
Totol
Messages: 3
Registered: July 2004
Junior Member
Hi,

I have a Query in a report but it is giving a message that 'missing right parenthesis'. The query is given below. Can anyone please help me?

SELECT ID,NAME,BASIC,BAAR,BAAD,totalba FROM BACK_HISTORY
WHERE basic in (SELECT ALL BACK_HISTORY.basic
FROM BACK_HISTORY
where (paydate='01-jun-2004')
=
SELECT ALL BACK_HISTORY.basic
FROM BACK_HISTORY
where (paydate='01-may-2004'))
AND PAYDATE='01-jun-2004' and BAAR<>0 OR BAAD<>0
Previous Topic: How to use bind parameters in Report Parameter list trigger
Next Topic: Report Pritning - Pagesetup Problem
Goto Forum:
  


Current Time: Thu Feb 29 23:34:59 CST 2024