Re: Aggregate with comparison
SQL isn't a complete computer language. Far from it. In particular, it doesn't understand pointers at all, eg foreign keys are implemented not as in your Table B, but rather by declaring a literal, fixed relationship between the names of a column in one table and another column in another table.
That is, SQL is literal-minded, so your "simplified" table setup, with the name of a table's column treated as data in another table, wouldn't cause any heartburn in a full computer language like C, but makes your SQL problem much more difficult.
So I'd ask you to address the questions I asked above.
Subject
Written By
Posted
September 29, 2015 12:41PM
September 29, 2015 04:23PM
September 30, 2015 12:45PM
September 30, 2015 03:23PM
September 30, 2015 03:45PM
Re: Aggregate with comparison
October 01, 2015 10:32PM
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.