In SQL, multiple tables can be combined using JOIN statements to retrieve data from related tables based on common columns, enabling complex queries and data analytics.