The CREATE TABLE AS SELECT (CTAS) statement allows you to create a new table directly from the results of a query, including joining tables. It automatically determines the column types based on the query's result set, ensuring they match the source tables. This minimizes the number of operations required.