Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private final String custNoInsQuery=
- "select count(distinct tbc.id) "
- + "from Tb_Customer tbc "
- + "join Tb_Insurance tbi on tbi.customerId = tbc.id "
- + "join Tb_Model tbm on tbi.modelId = tbm.id "
- + "where tbm.model=:model "
- + "and :date not between tbi.dateFrom and tbi.dateTo ;";
- private final String allCustQuery=
- "select count(c.id) "
- + "from Tb_Customer c;";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement