Re: select * from nmensagem m, nusuario...

> 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