Expand|Select|Wrap|Line Numbers
- SELECT
- ge.*, ge.concept AS glossarypivot FROM s_glossary_entries ge WHERE (ge.glossaryid = '161' OR ge.sourceglossaryid = '161')
- AND (ge.approved != 0 OR ge.userid = 361)
- AND concept = 'م'
- ORDER BY ge.concept
but unfortunately, it returns empty result ..
However, if I run the same query on mysql database, it works well and displays the correct result ..
What should I do in order to get this query working the right way on oracle 10 database?