In real-time scenarios what do u use instead of Joins?

Please let me know if JOINS are not used in real-time scenarios. Is it true that you have to use FOR ALL ENTRIES instead of JOINS in Select statements.

Also, let me know if TABLES statement and NESTED LOOPS not used in real-time scenarios?