Re: SQL problem

jop wrote:

> 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.

I understand that English is likely not your primary language ... but it is very difficult to understand exactly what you are doing and exactly what you are asking. Perhaps you can get someone to help you write a more detailed description. Many of us can probably help you if we understand exactly what the situation is.

But just to take a shot at it look at GROUP BY.

Daniel A. Morgan Received on Thu May 10 2001 - 23:23:41 CDT