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 mildBut I spat like a woman And I sulked like a childI have lived behind
thewalls That have made me aloneStriven for peace Which I never have known
 
Dire Straits, Brothers In Arms, The Man's Too Strong (Knopfler)