SELECT a.* FROM fmt_answers_75 a INNER JOIN users u ON u.id = a.created_by INNER JOIN persons p ON p.id = u.person_id WHERE 1 AND a.deleted = 0 AND a.archived = 0 AND ( p.firstname LIKE '%Aden%' OR p.lastname LIKE '%Aden%' OR p.othernames LIKE '%Aden%' ) AND a2.date_created LIKE '%2013-03-27%' AND a3.question_id = 17264 AND (a3.value = 'Saadhuumaay' OR a3.value = 'Surgudud' OR a3.value = 'Unaa' ) AND a.value = 'Male' first simplify the query to something like this and then just replace using positions. The where clause implies filter and oracle will optimize the query for you. Gave the same answer there. On Tue, Apr 16, 2013 at 1:05 PM, Ken Muturi <muturiken@gmail.com> wrote:
Guys who can help me solve this, Its been on stackoverflow for days without a comment
http://stackoverflow.com/questions/15948884/generate-sql-query-from-culmulat...
_______________________________________________ skunkworks mailing list skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- Kore Francis Njenga Running and Walking are only breaths apart.