Posted by --CELKO-- on 03/25/07 22:56

Please post DDL, 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. It is very hard to debug code when you do not let us
see it.

Next, get **any** book on RDBMS. Read the chapter about getting rid
of repeated groups in a table -- it is called First Normal Form (1NF)
and it is the foundation of RDBMS.

There is no such thng as a magical universal "id" -- it hs to be the
identifer of a particular kind of entity in your data model.

[Back to original message]