Posted by --CELKO-- on 04/16/07 17:29

Think in Sets! A table can be a set of entities and that table must
have *all* for the attributes of that entity. I think you need an
"access_status" attribute in the Users table or you need a
relationship table that puts a user_id and a resource_id paired.

>> Sorry for my bad English. <<

No problem. 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.

[Back to original message]