Creating a foreign key on the Union of two tables

Поиск
Список
Период
Сортировка
От saads@umich.edu (Saad Saeed)
Тема Creating a foreign key on the Union of two tables
Дата
Msg-id a811aba0.0304061353.664e2263@posting.google.com
обсуждение исходный текст
Ответы Re: Creating a foreign key on the Union of two tables
Re: Creating a foreign key on the Union of two tables
Re: Creating a foreign key on the Union of two tables
Список pgsql-sql
I have 2 tables "A" and "B" in mySQL. They both have an attribute 'id'
which is unique between the 2 tables. I want the union of these 2
attributes to be a foreign key in a 3rd table "C". How do I specify
this constraing in sql (mySQL) in table C? And for complex reasons I
cannot merge the 2 tables A and B.

Thanks,

-Saad



В списке pgsql-sql по дате отправления: