Hi,

I'm new to HQL.

I just want to ask if for example i have this 2 tables

IP | Subnet
-------------------------------
192.168.1.1 | 192.168.1.0
192.168.1.2 | 192.168.1.0
192.168.1.3 | 192.168.1.0


Subnet IP | Subnet Name
--------------------------------
192.168.1.0 | Main Subnet
176.26.2.1 | testsubnet
172.56.3.1 | Lab_subnet

I want to count the number of IP in all the subnet and the output should be this

Subnet IP | Subnet Name | IP Count
-----------------------------------------------
192.168.1.0 | Main Subnet | 3
176.26.2.1 | testsubnet | 0
172.56.3.1 | Lab_subnet | 0

But the problem is that it only shows:

Subnet IP | Subnet Name | IP Count
-----------------------------------------------
192.168.1.0 | Main Subnet | 3

I want to show the row with 0(zero) result.

Please help. Thank you in advance.

Could we see your code that produces this? Are you doing a unqiue result query, or querying for a collection to be returned?