Inner Joins vs For all Entries.

I have to code with some tables which contain vary large amount of data. Can you please explain the cases where I should use inner joins over for all entries or vice versa, to get better performance..? Is it true that for all entries does not function properly for more than 60000 records?

Regards

Liji