Re: brain-teaser with CONSTRAINT - any SQL experts?

Uwe said:
> how about using 2 tables with according unique/primary key constraints and a
> view to actually access the data (mixing the 2 tables into one) ?

Oliver said:
> Create a separate table with the two columns name and isbn which are
> that table's primary key; on the main table, create a foreign key to the
> new table

But my original email said:
> > I know it's tempting to say, "just link a separate table for the book
> > and don't store the book name" but let's just pretend that's not an
> > option


For reasons not worth going into, creating a separate table for the
code and name is not an option.  It has to be a self-contained
restriction inside this table.

Perhaps there's another way, using triggers or something?

Any other ideas?