On Mon, Aug 4, 2008 at 1:02 PM, David Wilson <david.t.wilson@gmail.com> wrote:
> On Mon, Aug 4, 2008 at 2:08 PM, Rajarshi Guha <rguha@indiana.edu> wrote:
>
>> select count(aid) where cid = 123 and cid = 456;
>>
>> but I was wondering whether I could construct a single SQL statement to do
>> this.
>>
>> Any pointers would be appreciated,
>
> Typed into gmail, so may need some tweaking, but something to the effect of:
>
> select count(*) from table a inner join table b on a.aid=b.bid group
> by a.cid,b.cid;
>
> should do the trick, I'd think...
But then you need remove the dups where you got:
667 999 2
999 667 2