> 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]
