[thelist] MySQL: from lookup tables to flat table
kasimir-k
evolt at kasimir-k.fi
Wed Apr 19 12:50:59 CDT 2006
Dear List,
perhaps something simple, but today the answer just keeps escaping me.
I have tables
persons - personId, name
fields - fieldId, fieldName
types - typeId, typeName
persons_x_fields - personId, fieldId
persons_x_types - personId, typeId
A person may belong to 0 or more fields and be of 0 or more types.
What kind of query would give a table like this:
personId, name, [field1, field2, ...], [type1, type2, ...]
i.e. field and type columns are comma separated lists which can also be
empty.
thanks,
.k
More information about the thelist
mailing list