who am i please answer

Viv 2017-12-12 15:31:35

i need some help.in the plan i see that its saying "No Join Predicate" as well as estimated and actual rows are not matching even though stats are updated.Wondering how can this query be finetuned