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

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(*) M

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 ret

[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 A