Concatenate three tables

[krithikarees]

I have three tables with all same fields - except the for the field sign data , Which contains different amounts but same field name . how do I concatenate all these three tables into one table and have amount fields show up as three different fields.

Example:

Actuals:

Load

Account_Exp,

Profit center,

costcenter,

signdata

from

abc;

Budget:

Load

Account_Exp,

Profit center,

costcenter,

signdata

from

abc;

forecast:

Load

Account_Exp,

Profit center,

costcenter,

signdata

from

abc;

Thanks in advance.

[marcus_sommer · Accepted solution]

Just renaming them like:

...

signdata as signdataActuals,

...

signdata as signdataBudget,

...

signdata as signdataForecast,

...

- Marcus