Re: Help with subselect (first time)

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>