Subject | Foreign Key on 2 or more columns |
---|---|
Author | svanderclock |
Post date | 2009-09-23T12:59Z |
hello,
in tableA i have some record with the field ID_contact that point to the table ContactA or to the table ContactB. so in this way i can not create a foreign key on my field ID_Contact.
How to do ? i thing by stored procedure, but what is the best way and the most efficient way to do that in store procedure ?
thanks you by advance
--
stephane
http://www.arkadia.com/usa/real-estate/for-sale/france/ile-de-france/paris/listings/
http://www.arkadia.com/fra/immobilier/vente/france/ile-de-france/paris/annonces/
http://www.arkadia.com/rus/real-estate/for-sale/france/ile-de-france/paris/listings/
in tableA i have some record with the field ID_contact that point to the table ContactA or to the table ContactB. so in this way i can not create a foreign key on my field ID_Contact.
How to do ? i thing by stored procedure, but what is the best way and the most efficient way to do that in store procedure ?
thanks you by advance
--
stephane
http://www.arkadia.com/usa/real-estate/for-sale/france/ile-de-france/paris/listings/
http://www.arkadia.com/fra/immobilier/vente/france/ile-de-france/paris/annonces/
http://www.arkadia.com/rus/real-estate/for-sale/france/ile-de-france/paris/listings/