You have not clearly defined when you want to execute SQL queries. If you want to access a DB from the LHS you can use the "from" keyword. Note the results need to be time-constant i.e. not change on successive calls. If you want to access a DB from the RHS it is plain Java (or MVEL depending upon your rule dialect). See the documentation for more information. ________________________________ From: rules-users-bounces(a)lists.jboss.org [mailto:rules-users-bounces@lists.jboss.org] On Behalf Of Amila Silva Sent: 23 June 2009 07:55 To: rules-users(a)lists.jboss.org Subject: [rules-users] How to execute the SQL query using drools hi All, I have requirement like to execute the sql queries through drools. is there are way to do it? please let me know asap. thanks amila silva