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
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!