hi
I have a query I want to change it in fetchXML.
Select * from new_periodtotal
Join product on product.pruductid = new_periodtotal.product
Join new_program on new_program.product = new_periodtotal.product
Problem is there is no direct relationship with new_periodtotal and new_periodtotal both have relationship with Product. how I convert it in fetchXML
query.