Re: where clause

[Peter Brawley]

... order by RecDate desc, Related desc, Placekey desc limit 55 ...

Or if you want the asc order then ...

select * from (
  Select * 
  from Records 
  where Patno = :nPatno 
  order by RecDate, Related, Placekey
) a
limit 55;