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
> 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
2 matches
Mail list logo