The query involves quite complex aliases/self joins. If you can help out please PM me. Cheers Notting