query for a report . Pl Help

[016]

select customer.name, case.caseid, case.customerid, case.status, case.datecreated from case, customer where CASE.CUSTOMERID = CUSTOMERR= customerid, and case.status = 'open' and ((dateDiff(&quot;d&quot;, [case.datecreted], now())&gt;15<br>(i have 2 tables : case and customer&nbsp;&nbsp;the commun fild for both is customerid).<br>HELP ME PLEASE. THANKS<br><br>(

 

[elizabeth]

what is the problem or question?

 

[gyma]

if your above sql statement is written exactly as you have it in your program, there are some problems with it - BUT, I think you were in a bit of a hurry to convey the problem and overlooked QCing the statement - I do it myself.<br><br>all that to say - check the parens around your 'dateDiff' - they're not equal in number<br>hth..