Inner Joins in SQL Giving Incorrect Results

[dclements]

test [112] > select * from test2 inner join test3 on (test2.val = test3.value)
    inserted    1   foo
    inserted    2   bar

test [113] > select * from test2
    inserted    1   foo
    inserted    2   bar

test [114] > select * from test3
    inserted    2   maho
    inserted    3   foo

Various other combinations in the ON clause that I'd expect to throw exceptions or give the correct result return the same wrong answer.