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

Report message to a moderator

Previous Topic: How to use bind parameters in Report Parameter list trigger
Next Topic: Report Pritning - Pagesetup Problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Apr 28 13:08:36 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.