Posted by no on 10/04/88 11:50

Hi

I have 2 tables ("records" and "metadata") that I can join together -
no problem. But I want a select that brings out the columns in table
"records" with the data in the second table also as columns. Like
this:

"records":
id, person
1, 'john smith'
2, 'bill jones'
3, 'fiona wells'

"metadata":
id, recordid, data
1,1,'male'
2,1,'manager'
3,1,'BMW hatchback'
4,2,'male'
5,2,'cook'
6,3,'female'
7,3,'director'
8,3,'motorbike'
9,3,'company jet'

(note there are not always the same number of metadata rows per
record)

I would like output similar to::
'john smith', 'male', 'manager', 'BMW hatchback'
'bill jones', 'male','cleaner'
'fiona wells', 'female', 'director', 'motorobike', 'company jet'

Thanks
Chris R.

• Next in forum: Re: want rows in 2nd (joined) table listed as columns with 1st
• Prev in forum: Re: Learning php Sql -
• Thread view: want rows in 2nd (joined) table listed as columns with 1st

[Reply to this message]