Question about fields in views / queries.

Hey all,

I have a quick question, i am quite new with Dynamics AX so please forgive me for asking this but,
How can i make a field for a view or query which calculates a certain value. for example:

Field A = 12 Field B = 2 Field C = a+b = 14 <

---

this is the field i require.

Or to merge 2 seperate field values in to 1.

Field A = Firstname. Field B = Lastname. Field C = a+b = Firstname Lastname. <

---

this is the field i require.

I can create the above mentioned examples easy in SQL server, but for some reason Dynamics AX does not see the views i create in SQL server (SQLServer does see the views i create in Dynamics though).

I hope anyone of you is able to help, many thanks in advance,

Kind regards,


Christian