Is the above query returns the records? If yes, then use your query and it should return the records. If the records are not returning, means there may be some issue which the data when performing the join operations.Hope it will be helpful to you.Regards,Pawan Awasthi(DNS MVM)+91 8123489140 (whatsApp), +60 14365 1476(Malaysia)pawansoftit@gmail.com