Re: Insert First Row

[Peter Levy <plevy@xxxxxxxxxxxx>]

Of course the problem is that the XMSMN1 field isn't distint. You'll 
have to use MIN or SUM on it.

INSERT INTO NEWSYS/EMLCMP (EMLADDR, EMEMP#) SELECT XMMAIL, MIN(XMSmn1) 
FROM posmstp WHERE xmmail <> ' ' GROUP BY XMMAIL, XMSmn1


Michael Ryan wrote:
> I thought I could do this, but it's not working for me. Here's my SQL
> statement:
>
> INSERT INTO NEWSYS/EMLCMP (EMLADDR, EMEMP#) SELECT DISTINCT XMMAIL,
> XMSmn1 FROM posmstp WHERE xmmail <> ' '
>
> I have records in posmstp like this:
>
> XMMAIL     XMSMN1
> A_Value      501
> B_Value      123
> A_Value      789
> C_Value      555
>
> I want the resultant table to be:
>
> XMMAIL     XMSMN1
> A_Value      501
> B_Value      123
> C_Value      555
>
> In other words, I just want the values from the first XMMAIL record I
> encounter. I though the DISTINCT would do that. What do I need to do?
>
> TIA
>