[PHP] sql faq

2003-09-24 Thread Jonatan Pugliese. 
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  

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

Re: [PHP] sql faq

2003-09-24 Thread Dan Anderson 
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

Re: [PHP] sql faq

2003-09-24 Thread Curt Zirzow 
* Thus wrote Dan Anderson ([EMAIL PROTECTED]):
 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

Also defining MaeSeguro.NroSocio as not null will make things even
faster with the index.

Curt
-- 
I used to think I was indecisive, but now I'm not so sure.

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

Re: [PHP] sql faq

2003-09-24 Thread Dan Anderson 
I just wanted to add that if you don't need all the information in
MaeSocio or MaeSeguro when doing a select, it is best to use:

SELECT NroSocio, whatever else you need FROM MaeSeguro;

-Dan

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