Re: Query producing default values

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

Query producing default values

I have a query which scans a subscription databse to locte 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 when for a given person such a subscription exists. If none exists, as expected the query produces

Re: Query producing default values

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 person

Re: Query producing default values

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! --

Re: Query producing default values

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! Reason for

RE: Query producing default values

: 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 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

Re: Query producing default values

[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