sql faq
| From: | Jonatan Pugliese. | Date: | Wed, 24 Sep 2003 16:30:33 +0000 |
| Subject: | sql faq | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-163775@lists.php.net to get a copy of this message | ||
select MaeSocio.* from MaeSocio
LEFT JOIN MaeSeguro ON MaeSocio.NroSocio=MaeSeguro.NroSocio
where MaeSeguro.NroSocio is null
MaeSeguro.NroSocio is not null
count(*) MaeSocio = 354000
count(*) MaeSeguro=108000
how i can retype this query?
Jonatan Pugliese
Area Sistemas
ACA - Automovil club Argentino
4808-4676 / 4663
www.aca.org.ar