I want to know about one query.
I have two views and I want to get the sum of count of two view ex
I have a query like
select record_identifier from records where
rownum<(40-(select count(*) from customer_view+select count(*) from
unit_view));
But this is not working in oracle.
Is there any other way to do this without writing a function
--
Best Regards
- Savita
----------------------------------------------------
Hewlett Packard (India)
+91 80 2051288 (Phone)
847 1288 (HP Telnet)
----------------------------------------------------