Thanks to all those who provided feed back.
As a result I found two ways of solving my problem, one is going along the LEFT
JOIN track, and the other one is to run a script before doing the query itself
whioch is doable in my environment without modifying the core software and
which can then do ea
[EMAIL PROTECTED] wrote:
Jacques Brignon <[EMAIL PROTECTED]> wrote on 11/09/2005 09:58:07 AM:
I have a query which scans a subscription database to locate the most recent
expiration date of the subscription to a given periodical or service to compute
the start date of a renewal.
It works fine wh
ginal Message-
From: Jacques Brignon [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 09, 2005 9:19 AM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: Query producing default values
Thanks, that makes a lot of sense.
My only problem is that I am using here a standard piece o
In article <[EMAIL PROTECTED]>,
Jacques Brignon <[EMAIL PROTECTED]> writes:
> Thanks, that makes a lot of sense.
> My only problem is that I am using here a standard piece of code on the
> application side and I would hate to modify it, the thing I have all liberty
> to
> change is the query! Rea
Thanks, that makes a lot of sense.
My only problem is that I am using here a standard piece of code on the
application side and I would hate to modify it, the thing I have all liberty to
change is the query! Reason for trying to ask the query itself to tell me if
there is nothing in the DB!
--
Ja
Jacques Brignon <[EMAIL PROTECTED]> wrote on 11/09/2005 09:58:07 AM:
> I have a query which scans a subscription databse to locte the most
recent
> expiration date of the subscription to a given periodical or serviceto
compute
> the start date of a renewal.
>
> It works fine when for a given pe
