On Wed, 2003-09-24 at 12:30, Jonatan Pugliese. wrote:
> 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?

<Stab in the dark>
SELECT * FROM MaeSocio WHERE ((MaeSocio.NroSocio = MaeSeguro.NroSocio)
AND (NroSocio = NULL));
SELECT * FROM MaeSeguro WHERE MaeSeguro.NroSocio = MaeSocio.NroSocio;

Process the data from there.

Oh, and index MaeSeguro.NroSocio.  That will make finding NULL values
easier. I think.  :-D

</Stab in the dark>

Let me know if I was right or just...erm...stabbing in the dark.

-Dan

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to