Microsoft Dynamics Axapta Technical,Functional Coverage

The complete syntax for the While select statement in axapta [while] select [reverse] [firstfast] [firstonly] [firstOnly10] [firstOnly100] [firstOnly1000] [forupdate] [nofetch] [crosscompany] [forcelitterals | forceplaceholders] [forcenestedloop] [forceselectorder] [repeatableRead] [validTimeState] [ * | <fieldlist> from] <tablebuffer> [ index [hint] <indexname> ] [ group by {<field>} ] [ order by {<field> [asc][desc]} ] [ where <expression> ] [ outer | exists | notexists ] join [reverse] [ * | <fieldlist> from] <tablebuffer> [ index <indexname> ] [sum] [avg] [minof] [maxof] [count] [ group by {<field>} ] [ order by {<field> [asc][desc]} ] [ where <expression> ] ] <fieldlist> ::= <field> | <fieldlist> , <field> <field> ::= fieldname | <function>(<field>)

Complete syntax of while select statement [while] select [reverse] [firstfast] [firstonly] [forupdate] [nofetch] [crosscompany] [forcelitterals | forceplaceholders] [forcenestedloop] [forceselectorder] [ * | <fieldlist> from] <tablebuffer> [ index [hint] <indexname> ] [ group by {<field>} ][ order by {<field> [asc][desc]} ] [ where <expression> ] [ [ outer | exists | notexists ] join [reverse][ * | <fieldlist> from] <tablebuffer> [ index <indexname> ][ aggregate [sum] [avg] [minof] [maxof] [count]][ group by {<field>} ] [ order by {<field> [asc][desc]} ][ where <expression> ]]<fieldlist> ::= <field> | <fieldlist> , <field> <field> ::= fieldname | <function>(<field>) <function> ::= sum | avg | minof | maxof | count