What are the SQL queries to pull up the last 10 patients I diagnosed with diabetes, sorting from mor

What are the SQL queries to pull up the last 10 patients I diagnosed (in the diagnosis table) with diabetes, sorting from more recent to last



I wrote the wrong name on a referral. I know the patient was recently diagnosed with diabetes.



Is there a way to retrieve the info I want ?

select u.fnames, u.surname from users u, diagnoses d where u.uid = d.patient and d.ic9 like '250.%' and d.created > '15-Aug-2007' order by d.created DESC


this assumes you're using IC9

thx. I want mostly the word diabetes ... not the IC9.

doesnt work.

Or, try Reports/Query/Examples - example 1 and change it to diabetes

am i putting this in the right spot ?

Yes ....

select u.fnames, u.surname from users u, diagnoses d where u.uid = d.patient and d.diagnosis like '%diabetes%' and d.created > '15-Aug-2005' order by d.created DESC

Works.

Here's another method

http://compkarori.no-ip.biz:8090/Documentation_Index/Reports/Queries

BTW, 2007 would have been sufficient!