@lists.mysql.com
Subject: RE: Auto Fill blank Rows
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
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
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
To get a blank line instead of NULL you could simply wrap the reference
in an IFNULL function:
select dummy.row_id,IFNULL(real.reference,'') as Reference from dummy left join
real on
real.row_id=dummy.row_id;
Phil wrote:
you could do something like
select dummy.row_id,real.reference