(Q) Data Browser Newbie

Hi all.

I have a simple query I hope someone can help this poor newbie with...

2 tables:

_______________________             _____________________


|      DOCUMENT       |             |   LIBRARY COPY    |


|=====================|             |===================|


|    DOCUMENT_ID      |<------------|   DOCUMENT_ID     |


|---------------------|             |-------------------|


|      TITLE          |             |    COPY_ORDER     |


|---------------------|             |-------------------|


|   BLAH BLAH BLAH    |             |    LIBRARY_ID     |


|---------------------|             |___________________|


|      ETC....        |

My problem is this...

There may be several copies of a document stored at different libraries. I need to create a column that replaces LIBRARY_ID if a document IS in multiple libraries and populate all the library ID's in that column instead of listing the same document many times with a different library ID each time.

I have been trying a WHERE EXISTS clause but can't get it running.

Thank you for your help,

Justin. Received on Wed Oct 08 1997 - 00:00:00 CEST