I have a query that works perfectly in version 4.1.10a-nt however it fails in 
version 
   4.0.24.  If someone has any ideas on how to fix the query to  run in 4.0.24, 
I would really appreciate it!  Thanks - code below:
  
  Select 
ibiBillMth,ibiBillYear,meter,ibiTotChg,id,userid,ibiDaysInBillingCycle,created
  from inputbillinfo t1
  where created = (select max(created)  from inputbillinfo t2
  where t1.ibiBillMth = t2.ibiBillMth and meter = "3" and userid= " 5" )
   ORDER BY ibiBillYear,ibiBillMth DESC
  



Immerman and Associates LLC
www.immermanassociates.com
[EMAIL PROTECTED]


Reply via email to