Thanks Peter - but I see two issues: 1. It returns data about only one id_secr_rqst - I want it to return data about every id_secr_rqst in the table. 2. Limit IMO is mysql specific (I hope I am wrong) is there something generic so I dont need to bother about which database I am running it against.
Thanks, Anoop On 5/23/05, Peter Normann <[EMAIL PROTECTED]> wrote: > > Hi Anoop > > Try: > > SELECT t1.id_secr_rqst, t2.name_rec_type, t1.dt_aud_rec > FROM isr2_aud_log t1, isr2_aud_log t2 > WHERE t1.id_secr_rqst = > t2.id_secr_rqst AND > t1.name_rec_type='Exception Resource' > ORDER by t1.dt_aud_rec DESC > LIMIT 2; > > Peter Normann > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- Thanks and best regards, Anoop