Yup! That's the kind of thing I was looking for - I just had a complete blank moment Thanks!!!
________________________________ From: Phil [mailto:[EMAIL PROTECTED] Sent: 12 March 2008 17:05 To: roger.maynard Cc: mysql@lists.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 <[EMAIL PROTECTED]> 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 !
