dear i need to get query from 3 tables i try to show how i need result in picture hope this will explain every thing.