• Code To Simulate OP's Table:

    CREATE TABLE customer (C_recid INT);

    INSERT INTO customer VALUES (50200),(50194),(50430),(50191),(1);

    Here is my solution:

    DECLARE @Lookup TABLE (C_recid INT, OrderSeq SMALLINT);

    INSERT INTO @Lookup VALUES (50200, 1), (50194, 2), (50430, 3), (50191, 4), (1, 5);

    SELECT

    c.*

    FROM

    customer c

    INNER JOIN

    @Lookup l

    ON c.C_recid = l.C_recid

    ORDER BY

    l.OrderSeq;

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]