FW: Dumping a query result to a table

Hi all,

I’ve been searching for the answer to this question but Google is not playing ball. Basically I have a terrible database adaptor (long story, but basically all I can use at the moment)  for Ruby that doesn’t seem to be compatible with PSQL 8.3, and so I can’t run this query below from it. So best thing to do I thought would be to dump the results of the query to a single table and just query that table. Is this possible? (and yes this query is a mess and is returning too many rows at the moment)

SELECT question_stem, option_text, author_id, QR.module_code, correct, weighting, question_option.option_id, feedback  FROM question Q

LEFT JOIN assessment_question_option_stat AQO

                ON AQO.question_id = Q.question_id

LEFT JOIN question_module

                ON question_module.question_id = Q.question_id

LEFT JOIN question_option

                ON question_option.question_id = Q.question_id

LEFT JOIN question_response QR

                ON QR.question_id = Q.question_id

LEFT JOIN question_objective

                ON question_objective.question_id = Q.question_id

LEFT JOIN question_keyword qk

                ON qk.question_id = Q.question_id

Kind Regards,

Dan Webb

____________________________________________________________

Swyddog Datblygu a Chynnal Systemau Gwybodaeth

Information Systems Development & Support Officer

Gwasanaethau Gwybodaeth             Information Services

Prifysgol Aberystwyth               Aberystwyth University

E-bost / E-mail: dbw@aber.ac.uk

Ffon / Tel: (01970) 628408

____________________________________________________________