Turning column into row

Hello,

I'm afraid this is a blody beginners question but I have no idea how
to perform a search sanely in the list archive.

I have a Table of certain items

create table item (
IdItem int,
Item varchar(64),
...
);

a lookuptable which defines some properties

create table property (
IdProperty int,
Property varchar(64)
);

and a table which defines the different properties which are possible for
a certain item:

create table tlkp_item_property (
IdItem int,
IdProperty int
);

So I can easily select all the properties of a certain item in a table
where the columns contain the properties. But I want to have an output
of the kind

Item 1: Property 1, Property 2, Property 3, ...
Item 2: <Properties of Item 2>
...

So I have to turn the different properties according to one item into
one field insead of one column.

How to do this sanely?

Kind regards

Andreas.