I have a query in existence already called #columns whereby it outputs a list of the distinct column headings over a number of specific existing tables:
I now want to create a new table which will have this list as it's column headings. I have attempted this problem but with no success. My attempted query looks something like this:
The second part of this code addresses the existing tables to be considered under the column headings.
I'm not sure if I'm even on the right track but any advice would be much appreciated, Thanks.