Howdy, Stranger!

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

Categories

JOINING UNIQUES

CSSKILLZ1CSSKILLZ1 Member Posts: 2
hello!

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.



so:

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.