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 !