Thanks for the help.
I had read the documentation, my problem is that after I've finished my example case I need build a live system. Our system contains a lot of data across multiple databases and hundreds of tables and I'm concious that specifically defining each column (so that I can create aliases) will be very time consuming. If I could just SELECT * on these tables and then manually add the joins it wouldn't have been as bad, hence my question.
I'll see if I can automate the creation of the script though.