temp_table: Creates a temporary table in the database
In rEHR: Manipulating and Analysing Electronic Health Record Data

Description Usage Arguments Details Examples

This function is useful if most of your work is on a subset of the database

1	temp_table(db, tab_name, select_query)

`db`	a database connection object
`tab_name`	character name for the teporary table
`select_query`	character the query that specifies the temporary table

The table will exist for as long as the database connection is kept open The Select_query argument will take the output from a select_events(sql_only = TRUE) based function

## Not run: 
db <- database("myCPRDdb")
temp_table(db, tab_name = "post_2005", 
           select_query = select_events(db, tab = "Referral", 
                                        columns = c("patid", "eventdate", "medcode"), 
                                        where = "eventdate > '2005-01-01'",
                                        sql_only = TRUE))

## End(Not run)