hi everyone. i'm relatively new to ax, i've searching on the web a way to create the next query but nothing seems to fit me needs.
select *
from (SELECT t1.field1, t1.field2, t2.field2, t2.field3, t2.field4, t2.field5, sum(t3.field2)
from t1 join t2
on t1.field1 = t2.field1 join t3
on t1.field1 = t3.field1
where condicions
group by 1,2,3,4,5,6
) a
union
select *
from (select t1.field1,t1.field2,t1,field3,t1.field4,t1.field5,t1.field6, sum(t2.field2)
from t1 join t2
on t1.field1 = t2.field2
where conditions
group by 1,2,3,4,5,6
) b
is there a way to make this in ax 2009?
i've searched how to make union and joins but there seems to be a restriction to join sentences(exists, non exists) while using union.
any information is welcome.
