To make things wierder...

[Eric Blankfield]

SELECT DISTINCT name,tons
FROM cdl
LEFT JOIN vessel ON (cdl.vessel = vessel.id)
WHERE tons between 74 and 76

offers this result set...
+-------------------+-------+
| name | tons |
+-------------------+-------+
| Betsy & Eliza | 74.44 |
| Elizabeth Rebecca | 75.06 |
| Susan Center | 74.15 |
+-------------------+-------+

while "SELECT DISTINCT name,tons FROM vessel WHERE tons BETWEEN 74 AND 76" gives the following...

+-------------------+-------+
| name | tons |
+-------------------+-------+
| Betsy & Eliza | 74.44 |
| Elizabeth Rebecca | 75.06 |
| Susan Center | 74.15 |
| Torpedo | 76.00 |
| Rumrunner | 75.00 |
+-------------------+-------+

What gives?