I have following situation on an Access Database.
ADA# NAME SPONSOR’s ADA#
123 JOHN 111
124 MIRA 111
125 SAM 124
126 RAM 125
127 MERRY 124
128 JOHNY 124
129 BUCH 111
111 MAJOR 110
112 SURAJ 110
Now I want to write a query which will give me listing sponsor wise e.g.:
ADA # Level Name SPONSOR’s ADA#
111 1 MAJOR 110
123 2 JOHN 111
124 2 MIRA 111
125 3 SAM 124
126 4 RAM 125
127 3 MERRY 124
128 3 JOHNY 124
129 2 BUCH 111
This has to be nested query but I am not sure go to go ahead…
Is anybody outthere to guide me
Thanks
