Marcos,

just out of curiosity:

what result do you get when you're doing a

SELECT JA_PEGO FROM V_ALOJ_GALPAO_PEGOS V
WHERE ID_ALOJ_GALPAO = 112

Do you get the result:

JA_PEGO
4320
1837
4320
4320
12421
12587
12587
12035

?

You said that ID_ALOJ_GRJ is an integer column. Is this valid for both
columns (in both tables)?

Luc.