Posted by --CELKO-- on 09/25/05 05:32

Please post completeDDL, so that people do not have to guess what the
keys, constraints, Declarative Referential Integrity, data types, etc.
in your schema are. Sample data is also a good idea, along with clear
specifications.

We never use prefixes like "pk-" or 'fk-" on data element names
(ISO-11179 rules). We also know that columns are not fields and rows
are not records. Names like "dt" and "code" beg that question "of
what??" Since you used a singular name for the table, does it have
only one row?

It looks like you are trying to build a self-referencing adjacency
list model for a hierarchy, but you never gave us constraints for that.
There are better ways to build a hierarchies. Can you explain your
problem?

[Back to original message]