| SQL [message #371582] |
Thu, 09 November 2000 12:24  |
Anita Deepak
Messages: 2
Registered: November 2000
|
Junior Member |
|
|
|
Can I get record count of two tables A & B as 2 columns of my SQL Query return. The query should return just 1 row with 2 columns (count from A,Count from B). Also I don't have any condition to join these two tables.
|
|
|
|
| Re: SQL [message #371583 is a reply to message #371582] |
Thu, 09 November 2000 12:41  |
Anita Deepak
Messages: 2
Registered: November 2000
|
Junior Member |
|
|
I found the answer myself before I got any reply over here.
Hope u would enjoy this..
Select (select count(*) from A) CountOfA,
(select count(*) from B) CountOfB
From Dual;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
