Re: Antw: many-many mapping between unique tables

> > I am facing a problem in mapping between two tables containing unique
> > entries
> >
> Then you need a third table T12 with columns x and y, that contains one
> row for each
> mapping of a x(i) with a y(j).

That's it. Normalize it. Relation T12 may also require the third field,
`direction', to specify whether this is T1 -> T2 or T2 -> T1. In general,
it'd be much better to re-design data layout.

--

Well I tried to be meek
And I have tried to be mild
But I spat like a woman
And I sulked like a child
I have lived behind the walls
That have made me alone
Striven for peace
Which I never have known

Dire Straits, Brothers In Arms, The Man's Too Strong (Knopfler)