On Fri, 26 Oct 2007 14:29:26 -0700, herbasher
<robmnl@gmail.com> wrote:

>On Oct 26, 11:06 am, herbasher <rob...@gmail.com> wrote:
>> Hello!
>>
>> I have three tables, mapping out a n:n relationship of authors and the
>> books they worked on:
>>
>> table 1: authors (id, name)
>> table 2: authorships (author_id, book_id)
>> table 3: books (id, name, bestseller tinyint)
>>
>> Here's two different queries I want to run:
>>
>> 1. Select each author, and how many books he has worked on.
>> 2. Select each author, and how many bestseller books (bestseller = 1)
>> he has worked on.
>>
>> Not exactly sure how to do this, can someone help me out with this?
>
>Is this hard? Possible? Expensive?

No, but it's Friday
I'm sure you'll get some response later.
--
( Kees
)
c[_] The desire to become a politician should bar you
for life from ever becoming one. (Billy Connolly) (#232)