>type is smallint

OK,
the clause Join "*" in table is cause the result. Because exist record in table a. but not need exist record in table c.

excuse the inglish