Received: from elch.de.uu.net (elch.de.uu.net [192.76.144.55]) by hub.org (8.10.1/8.11.0) with ESMTP id e9G8CRW26859 for ; Mon, 16 Oct 2000 04:12:27 -0400 (EDT) (envelope-from DieringG@eba-haus.de) Received: from kopo001 ([149.228.241.212]) by elch.de.uu.net (5.5.5/5.5.5) with SMTP id KAA04919 for ; Mon, 16 Oct 2000 10:08:00 +0200 (MET DST) Received: from EBA_DO-Message_Server by kopo001 with Novell_GroupWise; Mon, 16 Oct 2000 10:10:18 +0200 Message-Id: X-Mailer: Novell GroupWise 5.5.2 Date: Mon, 16 Oct 2000 10:09:50 +0200 From: "Gerhard Dieringer" To: Cc: Subject: Re: Antw: many-many mapping between unique tables Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Disposition: inline Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id e9G8CSW26862 X-Archive-Number: 200010/143 X-Sequence-Number: 1805 >>> Indraneel Majumdar 16.10.2000 22.13 Uhr >>> > Yeah you understand the problem perfectly. The third table will definitely > contain unique entries if you take both x and y simultaneously. I wanted > some way of mapping where I would not need to repeat individual values of > x and y. I am not from a maths background and have absolutely no idea of > database design. > > Is it possible to map the columns without repeating values? > > \Indraneel I don't know what type of data your columns x and y contain. If they are, for example, of type text and contain long strings, then it would be better to add an integer id column in each tables T1 and T2: x_id and y_id and use these ids in the table T12. Then you only have to repeat the (short) numeric vales in T12. But I think there is no way to totaly avoid any repetition. -------------- Gerhard