Re: [PHP] select * from nmensagem m, nusuario...

[Richard Lynch]

 select * from nmensagem m, nusuario u, nprefuser p where
 m.cdpreferencia=p.cdpreferencia and p.flag=1;

 With "m.cdpreferencia=p.cdpreferencia" I should get just the values there
 exists on m.preferencia and p.cdpreferencia?

No, because you have a record for every single nusario, since you don't
restrict any relation between u and m, nor u and p

--
Visit the Zend Store at http://www.zend.com/store/
Wanna help me out?  Like Music?  Buy a CD: http://l-i-e.com/artists.htm
Volunteer a little time: http://chatmusic.com/volunteer.htm



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP] select * from nmensagem m, nusuario...

[Augusto Cesar Castoldi]

Something is not working here:


select * from nmensagem m, nusuario u, nprefuser p where
m.cdpreferencia=p.cdpreferencia and p.flag=1;

With "m.cdpreferencia=p.cdpreferencia" I should get just the values there
exists on m.preferencia and p.cdpreferencia?

thanks,

Augusto


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]