[kashperuk]

when using filters, use the where clause instead
so:
join Claim on Claim.field=Order.field WHERE Order.field=99999

Hope this helps