Subject | [firebird-support] Merge records |
---|---|
Author | Pham Huu Le Quoc Phuc |
Post date | 2007-06-18T07:09:24Z |
Hi everybody!
I have 2 tables:
DEPARTMENTS(Code, Name)
EMPLOYEES(Code, Name, Address, DEPARTMENT (foreign key))
I want to merge 2 departments(from A into B) and udpate all foreign key’s tables. How I do?
Thanks
Mr. Phạm Hữu Lê Quốc Phục
* Add: 15 Quang Trung Street, Danang City, Vietnam
* Tel: 0511.810535 – Mobile: 0983.013467
[Non-text portions of this message have been removed]
I have 2 tables:
DEPARTMENTS(Code, Name)
EMPLOYEES(Code, Name, Address, DEPARTMENT (foreign key))
I want to merge 2 departments(from A into B) and udpate all foreign key’s tables. How I do?
Thanks
Mr. Phạm Hữu Lê Quốc Phục
* Add: 15 Quang Trung Street, Danang City, Vietnam
* Tel: 0511.810535 – Mobile: 0983.013467
[Non-text portions of this message have been removed]