How to write a query that will put multiple child records into 1 field

[sasd1234]

I have a table that is called lessonplan and another table that is called lessonplan_item. In lessonplan_item, there are many records that are linked to lessonplan via lessonplan_id. However there are many types of records in lessonplan_item. I need to write a query that will create a new field that will place all objectives from lessonplan_item that belong to lessonplan. Does anyone know how to do this?

Example:

lessonplan:

lessonplan_id, title, date
124, Mathematics-Addition, 08/29/07

lessonplan_item:

lessonplan_item_id, lessonplan_id, type, item_name
10, 124, OB, Students will count to 10
11, 124, OB, Students will add numbers using tens
12, 124, OB, Students will write all numbers on paper

What I would like is this:

title, date, type, item_name
Matematics-Addition, 08/29/07, OB, Students will count to 10; Students will add numbers using tens; Students will write all numbers on paper

Thank you for your help.

 

[PHV]

Have a look here:
faq701-4233

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886