Optimising my select.

how to speed this up. (In the process list it says the state is "Copying to tmp table" for ages).     Thanks   Carl Chambers   

SELECT

1 * 2 2 1 * 3 1 2 What I want to-do is create a select statement that lets me select all the contacts from the contacts table that have followed link 1 and link 2. I'm finding this hard without subselects. Th