Hi,
Thursday, November 11, 2004, 4:04:27 AM, you wrote:
CL> Given a database query thats returns results from a linking (or xref)
CL> table which includes repetition because of the joins:
CL> ++--+--+
CL> | id | title| subject |
CL> ++-
* Thus wrote Chris Lott:
> On Sat, 13 Nov 2004 06:30:14 +, Curt Zirzow
> <[EMAIL PROTECTED]> wrote:
>
> > > You might normalize the data a bit.
> >
> > agreed!
> >
> > Curt
>
> My data IS Normalized! The results you are seeing below are from
> joining together the books, subjects, and books
On Sat, 13 Nov 2004 06:30:14 +, Curt Zirzow
<[EMAIL PROTECTED]> wrote:
> > You might normalize the data a bit.
>
> agreed!
>
> Curt
My data IS Normalized! The results you are seeing below are from
joining together the books, subjects, and books_subjects xref table,
as I explained below. But
* Thus wrote Greg Donald:
> On Wed, 10 Nov 2004 09:04:27 -0900, Chris Lott <[EMAIL PROTECTED]> wrote:
> > Given a database query thats returns results from a linking (or xref)
> > table which includes repetition because of the joins:
> >
> > ++--+--+
> > | id |
On Wed, 10 Nov 2004 09:04:27 -0900, Chris Lott <[EMAIL PROTECTED]> wrote:
> Given a database query thats returns results from a linking (or xref)
> table which includes repetition because of the joins:
>
> ++--+--+
> | id | title| subject |
Don't know what version of MySQL you are using, but I upgraded to 4.1
so that I could use the GROUP_CONCAT function, which does what you are
looking for.
http://dev.mysql.com/doc/mysql/en/GROUP-BY-Functions.html
Otherwise, your front-end will need to do the rolling up of the records.
On Nov 10,
6 matches
Mail list logo
