I am working on an application system refinement. There is a user profile table in the
current system. After the refinement, there are new separated roles, A and B, of the
users. The role A only has a few valid fields of the original profile table while the
role B still has the whole profile t
Coincidentally, I have a very similar case using some twists.
The table I want to insert data is something like
table A (
user01 int,
user02 int,
...
primary key (user01, user02),
CHECK ( user01 < user02 )
);
And the user table is:
tabe user_table (
user int constraint pk_user primary key UNIQ
Thanks, Christoph for your thought.
An alternative solution I have is to fetch the user table first and act according with
the retured value. It doesn't seem to have a single query solution.
v.
--
- Original Message -
DATE: Wed, 13 Aug 2003 13:40:53
From: Christoph Haller <[EM
