This SQL Query not produce proper output. this query is also checked in ms access database and works perfectly. but not works on h2 database. Query is below.
SELECT formList.type1,formList.typeSerial,formList.module,formList.type1Gujarati FROM formList GROUP BY type1, typeSerial,module,type1Gujarati having ( module='Report Pending Token Number' or module='Report Agent Wise Member' or module='Ledger Skim' or module='Period' or module='Status' or module='Skim Master' or module='Draw' or module='Item' or module='Report Date Wise Account' or module='Report Ledger Wise Account' or module='Report Ledger Group Wise Account' or module='Report Pending Gift Issue Wise' or module='Report Gift Entry Wise Skim' or module='Report Gift Issue Wise' or module='Report Bill Wise' or module='Report Receipt Wise' or module='Report Pending Draw Wise' or module='Report Pending Receipt Wise' or module='Receipt' or module='Payment' or module='Journal' or module='Contra' or module='Gift Issue' or module='Purchase' or module='GIFT Entry' or module='Bill Skim' or module='Receipt Skim' or module='All' or module='General' or module='Report Agent Statemen' or module='SMS Templates' or module='SMS Send' or module='City Simple' ) order by typeSerial Please help me to solve this issue. thanks. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
