On Thu, 2005-02-03 at 13:04 -0600, Rodolfo J. Paiz wrote:
> I will guess in advance that I'm missing something obvious, but I
> *think* I need a subselect here and I've never done those.
Following up on this thread, I've decided that it's impossible to use a
subselect for this purpose. Wrong tool. Now investigating joins...
For simplicity's sake's, let's say I have a query which returns this:
| month | days |
|-----------|------|
| 2005-01 | 31 |
|-----------|------|
| 2005-02 | 28 |
|-----------|------|
| 2005-03 | 31 |
|-----------|------|
And I have a second query which returns this:
| month | flts |
|-----------|------|
| 2005-01 | 11 |
|-----------|------|
| 2005-03 | 8 |
|-----------|------|
Is there a simple way to join those two result sets into one? What I'd
like to have is this:
| month | days | flts |
|-----------|------|------|
| 2005-01 | 31 | 11 |
|-----------|------|------|
| 2005-02 | 28 | 0 |
|-----------|------|------|
| 2005-03 | 31 | 8 |
|-----------|------|------|
Since I'm not always able to fly every month, the "flts" result set will
not have data for every month. In that case, I'd like to show a zero
value as shown above.
Can someone point me to the right part of the manual to read? Thanks!
Cheers,
--
Rodolfo J. Paiz <rpaiz@simpaticus.com>