Re: Storing "deleted" data

<zeldorblat_at_gmail.com> wrote in message news:1130769897.026173.216650_at_g49g2000cwa.googlegroups.com...
> >b)You can try to declare a foreign key reference to one table AND
another.
>
> That doesn't help, though. Consider the following:

 create table livePeople (

    livePersonID int not null,
    ...
 )

 create table deadPeople (

    deadPersonID int not null,
    ...
 )

create table People(

    personID int not null,
    ...
)

create table personComment (

     personID int not null,
     commentID int not null