table manipulation

H

hugh

Hi all

my db has a single table, Table1. Table1 is as follows:


AUTHOR;TITLE;PUBLISHER

rows are not unique; i.e. I can have more than 1 row with the same author.

What would be the SQL code to generate a table2 with the following
structure:

AUTHOR;TITLE-PUBLISHER;...;TITLE-PUBLISHER

where every author now has only 1 row and titles and publishers for
author are appended to the right as as may fields as necessary?

thanks!
 
R

Rick Brandt

hugh said:
Hi all

my db has a single table, Table1. Table1 is as follows:


AUTHOR;TITLE;PUBLISHER

rows are not unique; i.e. I can have more than 1 row with the same
author.
What would be the SQL code to generate a table2 with the following
structure:

AUTHOR;TITLE-PUBLISHER;...;TITLE-PUBLISHER

where every author now has only 1 row and titles and publishers for
author are appended to the right as as may fields as necessary?

thanks!
Click to expand...

A crosstab query might be able to give you that. Making such a table would be a
horrible idea. The result would be a spreadsheet, not a database table.
 
Top