Advertisement
Guest User

Untitled

a guest
Dec 10th, 2016
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.39 KB | None | 0 0
  1.     private final String custNoInsQuery=
  2.             "select count(distinct tbc.id) "
  3.             + "from Tb_Customer tbc "
  4.             + "join Tb_Insurance tbi on tbi.customerId = tbc.id "
  5.             + "join Tb_Model tbm on tbi.modelId = tbm.id "
  6.             + "where tbm.model=:model "
  7.             + "and :date not between tbi.dateFrom and tbi.dateTo ;";
  8.     private final String allCustQuery=
  9.             "select count(c.id) "
  10.             + "from Tb_Customer c;";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement