Re: Insert First Row

["Carel Teijgeler" <coteijgeler@xxxxxxxxx>]

Michael,

I would code it as 

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

Regards,
Carel Teijgeler. 

*********** REPLY SEPARATOR  ***********

On 3-10-2006 at 14:06 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?