i am a bit new to sql but i have a project that i would like to do entirely in sql/sql*plus/pl-sql etc...
so what i want to do is select all of the approved account numbers for a certain date range, be it a day, month, whatever, [B]but [/B]i want to use views instead of tables because i do not want to create/drop information in the database, I just want to run temporarily using views/select statements without really touching the database.
the account numbers are stored in two tables, CCS_LEGAL and APPROVED. the accounts also have a date associated with them, though the date may be different between the two tables; so the date for account A might be 3-AUG-2007 for APPROVED, while the date in CCS_LEGAL might be 14-AUG-2007. its still the same account number