I have 3 more joins on that select, it's all working fine but as soon as I add the inner join to transaction, all goes crazy. Anyway, thanks for that solution