SELECT
edge.source,
pf.source,
edge.cnt, 
pdf.cnt
FROM
(select source,count(*) as cnt from Tableone group by source) edge
inner join (select source,count(*) as cnt from Tabletwo group by source) pf
ON edge.source = pf.source
WHERE edge.source = 'Source1'

SELECT source,
SUM(CASE WHEN cat='A' THEN 1 ELSE NULL END) AS TableoneCount,
SUM(CASE WHEN cat='B' THEN 1 ELSE NULL END) AS TabletwoCount
FROM
(SELECT source,'A' as cat from Tableone
 UNION ALL
 SELECT source,'B' from Tabletw
)t
GROUP BY source

quote:

---

Originally posted by vision.v1


Am having two tables Tableone and Tabletwo, both the tables
have diff. no. of records...

I want to get count of both the tables, so i tried like:

SELECT
edge.source,
pf.source,
COUNT(edge.source) over(partition by 1) ,
COUNT(pf.source) over(partition by 1)
FROM
Tableone edge
JOIN
Tabletwo pf
ON
edge.source = pf.source
WHERE
edge.SOURCE = 'Source1'
GROUP BY
edge.source,
pf.source


but am getting records count as product of two tables...
please advise...

---

quote:

---

Originally posted by vijayisonly

Visakh...probably shud have been SUM instead of MAX?

SELECT source,
SUM(CASE WHEN cat='A' THEN 1 ELSE NULL END) AS TableoneCount,
SUM(CASE WHEN cat='B' THEN 1 ELSE NULL END) AS TabletwoCount
FROM
(SELECT source,'A' as cat from Tableone
 UNION ALL
 SELECT source,'B' from Tabletw
)t
GROUP BY source

---