View previous topic :: View next topic
|
Author |
Message |
bhaskar_kanteti
Active User
Joined: 01 Feb 2007 Posts: 123 Location: Hyderabad
|
|
|
|
Hi,
I want the total count of customer id from two table.
ie. If in my first table i had 5 customer id of 10000 and 3 customer id of 10000 in my second table. then the total count should be 8.
How can i get this. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
You might use:
Select count(*) from tab1 where custid = 10000
Select count(*) from tab2 where custid = 10000
Add the counts giving total for custid 10000 |
|
Back to top |
|
|
|