--- In firebird-support@yahoogroups.com, "Martijn Tonies" wrote:

>> In the interbase, my select worked, now doesnt´t work.

> Change it until "it works" again then.

> Or perhaps, tell us the error message so we can make an educated
> guess.

Sensible advice from Martijn, but you should also remove the
irrelevant noise that he failed to spot:

LEFT JOIN ParametrosContabeis PC ON NV.OpFis_Codigo =
PC.OpFis_Codigo
AND NV.OrFis_Codigo =
PC.OrFis_Codigo)

doesn't add anything to your query since you do not refer to the right
table of the left join at all (neither in the SELECT, nor in the WHERE
clause. However, I haven't heard that Firebird barks when feeding it
irrelevant joins, so your main problem is probably something else.

Set