Hello all,
I'm having a bit of an issue deciding how to go about solving my problem. I have different sets of data from which I'm going to harvest basically the same information. I would like to merge this separate reports into one which I can then use to join with other data. My background is in SQL, and there I would use a temp table to insert the result of my different queries. Then I could use this new temp table and join it with other tables to complete the data.
What do you guys suggest? Can/should I create temp tables to solve this issue (and if so, where can I find doco on temp tables for CacheSQL?)
Thank for your thoughts.
Daniel
