Join results from two queries

[Moisés Belchín]

Hi all,

I want to get two differents results from the same table, I mean:

SELECT count(*) as Lec FROM my_table WHERE fecha_lec < '2012-04-24';

SELECT count(*) as Rec FROM my_table WHERE fecha_rec < '2012-04-24';

I would like to join both results and launch only one query, is it possible?

Thanks so much.

[Siddartha Naidu]

This should be possible using this simple scheme:

SELECT

  SUM(IF(fecha_lec < '...', 1, 0)) as Lec,

  SUM(IF(fecha_rec < '...', 1, 0)) as Rec

FROM my_table;

[Moises Belchin]

Very clear and useful answer.

Thanks and best regards

Saludos.

Moisés Belchín.

2012/4/25 Siddartha Naidu <sna...@google.com>