Kareem Badr wrote:
> I should mention that free_space and size are defined as varchars, for
> some reason. Not sure if that has anything to do with the issues I'm
> seeing.
>
Do any of these fields contain NULL? as that will definately have an
impact upon both joins and upon calculations. (when using a numeric
field, it's always better to set the field NOT NULL, and default it to 0).

-- 
Bill King, Software Engineer
Trolltech, Brisbane Technology Park
26 Brandl St, Eight Mile Plains, 
QLD, Australia, 4113
Tel + 61 7 3219 9906 (x137)
Fax + 61 7 3219 9938
mobile: 0423 532 733

Reply via email to