Hello group I have been working on this sql script but I need some assistance. How do I take the row below (Source Table) and make the fields into columns
Ex. I would like to have columns the name Cash4Table---GaFiceTable---Yourtable---Your Date---Your Number
My script looks like this and I want to know what do I need to do. Thank you
This is how my information look now along with my sql script
PARAMETERS [Enter Date:] DateTime, [Enter YourNumber:] IEEEDouble;
SELECT "YourTable" AS SourceTable, YourDate, YourNumber
FROM YourTable
WHERE YourDate BETWEEN [Enter Date:]-1 AND [Enter Date:]+1
UNION ALL
SELECT "Cash4Table", YourDate, YourNumber
FROM Cash4Table
WHERE YourDate BETWEEN [Enter Date:]-1 AND [Enter Date:]+1
UNION ALL
SELECT "GAFiveTable", YourDate, YourNumber
FROM GAFiveTable
WHERE YourDate BETWEEN [Enter Date:]-1 AND [Enter Date:]+1
UNION ALL SELECT "MoonPhaseTable", YourDate, YourNumber
FROM MoonPhaseTable
WHERE YourDate BETWEEN [Enter Date:]-4 AND [Enter Date:]+1
ORDER BY SourceTable, YourDate;
SourceTable Cash4Table Cash4Table Cash4Table Cash4Table Cash4Table Cash4Table GAFiveTable GAFiveTable GAFiveTable GAFiveTable GAFiveTable GAFiveTable MoonPhaseTable MoonPhaseTable MoonPhaseTable MoonPhaseTable MoonPhaseTable MoonPhaseTable YourTable YourTable YourTable YourTable YourTable YourTable