Select statement
From: Steven Richardson (steve_at_cheltenhamdirectory.com)
Date: 10/26/04
- Next message: Joe Scalise: "Re: help with query please!!! max() and joins"
- Previous message: j1c: "Re: Loop though select statement"
- Next in thread: David Portas: "RE: Select statement"
- Reply: David Portas: "RE: Select statement"
- Reply: Alejandro Mesa: "RE: Select statement"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 26 Oct 2004 17:03:07 +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: Joe Scalise: "Re: help with query please!!! max() and joins"
- Previous message: j1c: "Re: Loop though select statement"
- Next in thread: David Portas: "RE: Select statement"
- Reply: David Portas: "RE: Select statement"
- Reply: Alejandro Mesa: "RE: Select statement"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
