I have very little Database Experience, and I need a little help. I am using sqlplus to manipulate an Oracle 10g database. I have two tables I want to use to create a new table. Table_1 has a column that references data in Table_2. I want my new table to contain all of the information from Table_1 + one column of Table_2. Table_2 includes data from a bunch of other tables I do not want. Table_2 also has a DATE column that is relevant. So I only want the information from Table_2 where it matches Table_1 AND where the DATE is after 11/15/09. IMG_SYSID is the column in both tables. IMAGE is the column from table_2 that I want to add to my new table along with all the information from table_1. "CREATE TABLE new_table_name AS SELECT * FROM Table_1" Will give me a copy of Table_1, right? Now how do I add the information from Table_2.IMAGE where Table_2.IMG_SYSID matches Table_1.IMG_SYSID AND DATE > 11/15/09 (between 11/15/09 and today). Is it a JOIN WHERE clause of some sort? Do I need to do it all in one query?