Join multple records
From: Steven Richardson (steve_at_cheltenhamdirectory.com)
Date: 09/14/04
- Next message: Mingqing Cheng [MSFT]: "Re: Connections query"
- Previous message: RobGT: "Re: Copying objects and data fails on relationships (I think)"
- Next in thread: oj: "Re: Join multple records"
- Reply: oj: "Re: Join multple records"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 14 Sep 2004 15:17:08 +0100
Anyone know how two join muliple records into 1.
I have 3 tables like the Pubs DB.
Authors
Titles
TitleAuthors
This allows for many to many relationships.
I need to be able to query this database so I can import titles & authors to
a system that does not deal with many to many relations ships & so want the
query to return the authors in one colum like below.
title_id fulltitle author1
title_id fulltitle author1, author2, author3
title_id fulltitle author2, author3
etc..
etc..
I would imagine there would be someway of doing this in a function or a
cursor.
Many Thanks
Steve
- Next message: Mingqing Cheng [MSFT]: "Re: Connections query"
- Previous message: RobGT: "Re: Copying objects and data fails on relationships (I think)"
- Next in thread: oj: "Re: Join multple records"
- Reply: oj: "Re: Join multple records"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
