How to join field values in Views in Dynamics AX 2009

I need to create a View for exporting some Product Data. Ideally I need to merge two fields values (maybe others if possible).

I know SQL in AX is not really proper SQL as I've tried:

Select field1 + field2 from table

Which should work and it doesn't

I have a feelin开发者_开发技巧g I could this with a method in the View, but I've never done this before and I can't find any decent examples anywhere.

Is what I want to do even possible, and if so how would I do it?

Edit

The reason I'm doing this is because I've started using Magento. Its not properly integrated with AX so I was going to create a view with all the data about a product and then do a manual import into Magento.

I want to combine the the SKU of the product with the color id or size id.

So PP1234 and BLU would become PP1234-BLU

try that

 select CAST(field1 AS varchar(number_characters)) 
 + CAST(field2 AS varchar(number_characters))
 from table

You can probably create a staging table, which you would be able to use for export, if it suits your purpose...

static void Test(Args _args)
{
    InventTable inventTable;
    StagingTable stagingTable;
    ;

    ttsbegin;

    insert_recordset stagingTable (ItemId, Field1, Field2)
        select ItemId, SourceField1, SourceField2 from inventTable;

    update_recordset stagingTable
        setting Field1 = stagingTable.Field1 + inventTable.SourceField2,
                Field2 = -stagingTable.Field2 + inventTable.SourceField1
    join inventTable
        where inventTable.ItemId == stagingTable.ItemId;

    ttscommit;
}

From looking around through the little amount of Documentation there is about Dynamics AX I don't think this can be done.

Seems strange the little amount of SQL you can do.

You don't mention why you want to add those two fields together, but if it is merely for presentation, then this can easily be solved by using a display method on the table instance.

public Amount myCustomMethod()
{
    return this.fieldA + thisfieldB;
}

Since you're using X++, and you're doing exporting, I don't understand why you can't do the calculation as a part of the export.

Hope this helps.