By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,434 Members | 2,884 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,434 IT Pros & Developers. It's quick & easy.

Many to many cross reference query

P: n/a

I am looking to pick up the relationship between items in a
cross-reference table. For example, searching for c OR f (bracketed
below to highlight them), I want to list the other right hand side keys
that are linked by the left hand side key. So in the below case, "a" is
linked 3 times due to (c), b is linked twice due to (c), d is linked
twice due to (c) and (c OR f) and finally e, linked once due to (c).

1 | a
1 | b
1 | (c)
1 | d
2 | a
2 | b
2 | (c)
3 | z
4 | a
4 | (c)
5 | (c)
5 | e
6 | (f)
6 | (c)
6 | d

Just wondering what the best way of doing this is, and how the result
can be ranked by the number of hits (so a,b,d,e) and how to get the
number of links (3, 2, 2, 1)

Hope this is clear. This has had me scratching my head for a while :/

Many thanks in advance!

Feb 1 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.