Re: help with simple db design
Posted by:
Bob Field
Date: April 02, 2006 09:16PM
You need to form your join properly. The comma-style join can lead to ambiguity and confusion, so use the explicit join syntax with a spelt-out ON condition.
SELECT GROUP_CONCAT(mh.Hobbie_ID ORDER BY mh.Hobbie_ID DESC SEPARATOR ', ')
FROM Member AS m
JOIN MemberHobby AS mh ON m.member_id = mh.member_id
WHERE m.Member_ID = '23'
GROUP BY m.member_id;
Subject
Written By
Posted
Re: help with simple db design
April 02, 2006 09:16PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.