>Ok, you are not (well maybe you will :o) going to believe how stupid this is. The field in both tables is vehi_id, not vehi_id in one and veh_id in the other. Now I KNOW I am seeing things when I didn't catch that ever last night! :o) I looked and looked at it looking for typos and never saw that!
:-)
But the query must give you an error: veh_id not exists or something like that.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.