Hi, I wonder why the conditions are in "having" and not in "where". Also, I would probably use "module in (...)" instead of that many "or" conditions. But that shouldn't change the result.
We would need to have a complete test case, including "create table" and "insert" statements. Regards, Thomas On Friday, April 24, 2015, Mayur Bhatt <[email protected]> wrote: > 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] > <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> > . > To post to this group, send email to [email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- 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.
