cross tab query
I have a project table with the following columns

    ProjectID, ProjectDescription

and a list data table which has the following columns

    ProjectID ListType Date Memo

Every project has many list type entries in the ListType Table.

What I want to do is run a query which will return something like this

    ProjectID, ProjectDescription, ListType1, ListType1.date, Listtype1.Memo, ListType2, ListType2.date, ListType.Memo

Againg, Every Project is coonected to a number of list type data.
I am using Microsoft SQL 2000. so the Pivot keyword doesnot work
cross tab query
===

I have a project table with the following columns

    ProjectID, ProjectDescription

and a list data table which has the following columns

    ProjectID ListType Date Memo

Every project has many list type entries in the ListType Table.

What I want to do is run a query which will return something like this

    ProjectID, ProjectDescription, ListType1, ListType1.date, Listtype1.Memo, ListType2, ListType2.date, ListType.Memo

Againg, Every Project is coonected to a number of list type data.
I am using Microsoft SQL 2000. so the Pivot keyword doesnot work