christheprogrammer
Programmer
OK, this shouls be easy. I am terrible with queries as I am a programmer and my mind works in loops much better. Anyway, say I have 2 columns in a table (obviously hypothetical):
monkey blue
chicken red
chicken blue
turtle green
chicken blue
monkey red
monkey blue
Now, I want the output to count up the unique pairs and produce the following:
monkey blue 2
chicken red 1
chicken blue 2
turtle green 1
monkey red 1
Probably a snap for somebody here - I appreciate the replies!
Cheers
Later
monkey blue
chicken red
chicken blue
turtle green
chicken blue
monkey red
monkey blue
Now, I want the output to count up the unique pairs and produce the following:
monkey blue 2
chicken red 1
chicken blue 2
turtle green 1
monkey red 1
Probably a snap for somebody here - I appreciate the replies!
Cheers
Later