I'm hoping someone can help me with a query that I'm trying to construct.

I have two tables, bills and bill_items. The tables are shown below.

BILLS
-->bill_id
-->bill_date
-->customer_last

BILL_ITEMS
-->bill_id
-->item

Given the table data shown below:

=== bills ===
1, 2011-01-25, doe
2, 2011-01-27, doe

=== bill_items ===
1, A001
1, A002
1, A003
2, A001
2, B004

I would like to construct a query that produces the following output:

Inv # | Date | Last Name | Items
1 | 2011-01-25 | doe | A001 A002 A003
2 | 2011-01-27 | doe | A001 B004

Worked brilliantly. Thank you so much for the response!