The complete syntax for the While select statement in MSD axapta


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>)