MySQL Forums
Forum List  »  General

Re: Query - multiple joins won't return any records
Posted by: Bad Programmer
Date: February 19, 2015 03:06PM

James:
I posted this on 6 different well known forums and you are the only one who came up with the answer: split the relations table into multiple tables.

With that I can accomodate multiple IDs of each entity type for a given score, I can use any existing relation for multiple scores and I can use INNER JOIN statements to find the records correctly.

I'm still working on it but so far it looks like this was the only viable solution.

Thank You!!

Options: ReplyQuote




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.