>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

With just SQL I don't think so.
Cetin