RE: Auto Fill blank Rows

["roger.maynard" <roger.maynard@xxxxxxxxxxxxxxx>]

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

________________________________

From: Phil [mailto:freedc.bok@xxxxxxxxx] 
Sent: 12 March 2008 17:05
To: roger.maynard
Cc: mysql@xxxxxxxxxxxxxxx
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.maynard@xxxxxxxxxxxxxxx> 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 !