SQL problem

From: jop <jop_at_novabase.pt>
Date: Thu, 10 May 2001 15:29:47 +0100
Message-ID: <3BxK6.512$7C.2011164@newsserver.ip.pt>

I have this problem:
I have 2 tables T1 and T2

T1: T2: (Association ID_Sn <-> ID_Ex)
ID_Ex,ID_Sn, Qtd ID_Ex ID_Sn Desc
12 1070 1 12 1070 some text
12 1090 1 15 1090 more text
13 1070 some diferent text
20 1090 more diferent text

T1 is filled by the user. I must let the user select an ID_Sn that is not associated with the current Id_Ex in T2. When I get (using SQL) the Total Qtd , id_sn and Desc I get duplicated rows.
I can I solve this?
thanks. Received on Thu May 10 2001 - 09:29:47 CDT