How to implement this query in Axapte?
SELECT count(*) FROM rec JOIN ( SELETC max(date) d, id FROM rec WHERE `Date`<"2014-02-03 00:00:00" GROUP BY id ) drec ON rec.id = drec.id AND rec.date = drec.d WHERE rec.value<>0; 
romeo
4,855 11 silver marks 28 bronze marks
Dmitry Dmitry
one
- Axapte, is this something proprietary? - romeo
- Er ... en.wikipedia.org/wiki/Microsoft_Dynamics_AX ? You wrote the word in two different ways, Google offers the third. - Athari
- This is Microsoft Dynamics AX and there is the programming language x ++ - Dmitry
|