S
svetelina
Hello all,
I have a problem with duplicated prim. keys.
I have a table which contains the same records twice, but
the specification is that since the records belong to two
diff. subgroubs of records within the table, I have to
keep them both. Example:
table 1
id id2 var var var
1 2 4 6 9
1 3 4 6 8
1 2 4 6 9
1 7 4 6 8
1 8 4 5 9
Table 2
id id2 var var var
1 2 4 6 9
1 7 4 6 8
The order of the tables s has to be preserved, and they
need to be linked. In table 1, first two records form one
group, sencond 2 another. Talbe two has to be matched to
group 2 but there is a duplicated record.
How can I link the tables? How can I make the prim keys
unique?
Sveta
I have a problem with duplicated prim. keys.
I have a table which contains the same records twice, but
the specification is that since the records belong to two
diff. subgroubs of records within the table, I have to
keep them both. Example:
table 1
id id2 var var var
1 2 4 6 9
1 3 4 6 8
1 2 4 6 9
1 7 4 6 8
1 8 4 5 9
Table 2
id id2 var var var
1 2 4 6 9
1 7 4 6 8
The order of the tables s has to be preserved, and they
need to be linked. In table 1, first two records form one
group, sencond 2 another. Talbe two has to be matched to
group 2 but there is a duplicated record.
How can I link the tables? How can I make the prim keys
unique?
Sveta