view problem

I *love* 6.4. It's fixed a tremendous amount of problems I've
been having, thank you so much.

I did, however, find a problem with a view I created. I'm
collecting rstat data, and the following query works great, but in a view
returns all data instead of unique data:

create view boottimes as
select distinct hostnames.hostname, rstat.boottime
from rstat, hostnames
where rstat.host_id=hostnames.host_id;

Any ideas?

--
SA, beyond.com My girlfriend asked me which one I like better.
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin(at)spy(dot)net>
| Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE
L_______________________ I hope the answer won't upset her. ____________