Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Just renaming them like:
...
signdata as signdataActuals,
...
signdata as signdataBudget,
...
signdata as signdataForecast,
...
- Marcus
Just renaming them like:
...
signdata as signdataActuals,
...
signdata as signdataBudget,
...
signdata as signdataForecast,
...
- Marcus