Is there a SQL statement that can take a one-to-many relationship between two tables and create a single table. The single table would be distinct yet contain combined data from the many-table.

Example:
Invoice table with one record per invoice and line item table with multiple line items.
Resulting table has invoice data and line items combined in one field (possible memo).

Thanks