I can`t get more than 10.000 results in a join command

[jjofret]

Hi, I would like to know if there is some way to create a query where I can get more than 10.000 results when I used the join command. 

Into the limits.conf file, I can´t edit the limit for more than 10.500 results.  Do you know some way to do this  ?, at today I have a file with more than 700.000 entries. 

[richgalloway]

Do you have to use join?  In general, they're not advised.  Please share your query and someone may be able to suggest an alternative.