How to get the COUNT of inactive regions?

[hemanthaanichet]

Hi QV People,

I have a data like below

Table 1:

Region	Region code	Branch Code
1	101	11
2	102	12
3	103	13
4	104	14
5	105	15
6	106	16
7	107	17
8	108	18
9	109	19
10	110	20

Table 2:

Region Code	Customer no	Loan Name
101	A001	Bike
102	B001	Car
103	C001	Supermarket
101	A002	Housing
104	D001	Business
102	B002	Personal
103	C002	Medical
104	D002	Housing
105	E001	Car
110	J001	Bike

My query is

In the above data only few regions have an entries in providing the loan to customer and remaining region doesn't have entries

1.Now i want to get the count of regions which doesn't have entries

2. i want to display those region as inactive region code

Regards,

Hemanth

[krishnacbe]

+ List box added