K
krisworld
I have 2 fields in my table
F1& F2
F1 F2
--------------
a aa
a aa
a bb
a cc
b aa
b bb
c cc
c cc
i need output as
a aa 2
a bb 1
a cc 1
b aa 1
b bb 1
c cc 2
I am bit confused for the query
can any give me some idea...
F1& F2
F1 F2
--------------
a aa
a aa
a bb
a cc
b aa
b bb
c cc
c cc
i need output as
a aa 2
a bb 1
a cc 1
b aa 1
b bb 1
c cc 2
I am bit confused for the query
can any give me some idea...