union with count? - Mailing list pgsql-sql

From Gerardo Herzig
Subject union with count?
Date
Msg-id 460A75ED.6070501@fmed.uba.ar
Whole thread Raw
Responses Re: union with count?  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: union with count?  (Richard Broersma Jr <rabroersma@yahoo.com>)
List pgsql-sql
Hi dudes, i have the following question
i have 2 tables with the same format, and i want to know if is there a 
possibility of using some sort of count(*) for achieving this result:
select a from table1 where (condition) union select a from table2 where 
(condition), count(a) group by a

The idea is having how many times (condition) is true for both tables.

Im not shure im explaining myself clearly, my english is not the best 
(as you can see ;)


Thanks!
Gerardo


pgsql-sql by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: Regular Expressions [progress]
Next
From: "A. Kretschmer"
Date:
Subject: Re: union with count?