I have this table structure:
id1 id2 1 2 1 3 2 1 2 4
id1 and id2 are not unique as you can see in the values. I need to retrieve those values that exists in the two columns meaning id1=1,2 id2=2,1. Any help?
Cheers and thanks in advance
Assuming that the combination of
A multicolumn index would greatly speed up such a query:
Use it without
Or, you can use those other techniques discussed under your prequel question, accordingly modified.