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;

Options: ReplyQuote


Subject
Written By
Posted
April 02, 2006 05:02AM
April 02, 2006 11:14AM
April 02, 2006 07:37PM
April 02, 2006 08:01PM
April 02, 2006 08:34PM
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.