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

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 Mailin

Re: [PHP] 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