Difference b/w SELECT AND FIELDSELECT in Dynamics AX extended….

When will Dynamics AX resolve an AX-SQL-Statement with a fieldlist in a fieldlist and when will Dynamics AX resolve an statement in a select * ?
In addition to the blog-entry “Difference b/w SELECT AND FIELDSELECT in Dynamics AX” by Santosh this entry completes this topic.