From: roger.maynard (roger.maynardcrayford.ltd.uk)
Date: Wed Mar 12 2008 - 12:18:29 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Yup! That's the kind of thing I was looking for - I just had a complete
blank moment
 
Thanks!!!

________________________________

From: Phil [mailto:freedc.bokgmail.com]
Sent: 12 March 2008 17:05
To: roger.maynard
Cc: mysqllists.mysql.com
Subject: Re: Auto Fill blank Rows

you could do something like

select dummy.row_id,real.reference from dummy left join real on
real.row_id=dummy.row_id;

would give NULL on the 'missing' rows,

On Wed, Mar 12, 2008 at 12:50 PM, roger.maynard
<roger.maynardcrayford.ltd.uk> wrote:

        Anyone got any bright ideas of how to solve this one?
        
        I have documents which can contain up to 15 rows of information.
        Each row as it is added to the document reference can have any
ROW_ID
        from 1 to 15 when it is added.
        
        I want to be able to "Auto Fill" the blank rows on a SELECT.
        
        eg
        
        data in table is
        
        ROW_ID | Reference
        ===================================
        1 | Reference Line 1
        3 | Reference Line 3
        9 | Reference Line 9
        11 | Reference Line 11
        15 | Reference Line 15
        
        RESULT REQUIRED is
        
        ROW_ID | Reference
        ===================================
        1 | Reference Line 1
        2 |
        3 | Reference Line 3
        4 |
        5 |
        6 |
        7 |
        8 |
        9 | Reference Line 9
        10 |
        11 | Reference Line 11
        12 |
        13 |
        14 |
        15 | Reference Line 15
        
        I've been playing about with joins on a "dummy" table containing
just
        rows 1 to 15, but am stuck in my thinking at the moment.
        
        Any help gratefully received
        
        Roger
        

--
Help build our city at http://free-dc.myminicity.com !

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]