Re: Cross table access query
> When you say hero_id_index, what is that representing?
hero_id_1 &c is a design mistake. As a rule of thumb, when you find yourself creating columns with _1, _2 &c suffixes, stop, because it's inefficient and messes up querying. There should be one hero_id column. Your _1 _2 and _3 indexicals need to be in their own column. To understand why, read about normalisation.
> I don't understand what the m and h are in the query.
Those are aliases, ie conveniences for simplifying query reading & writing. See the manual for query syntax (or any introductory sql text).
Subject
Written By
Posted
Re: Cross table access query
July 21, 2014 08:52AM
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.