problem in group by - Mailing list pgsql-sql

From Md Aminur Rashid
Subject problem in group by
Date
Msg-id 007a01c162bb$8e74a4e0$b003050a@mahindrabt.com
Whole thread Raw
List pgsql-sql
 

I have a table masterauthor which has columns as

AUTHOR NAME and  ID ( ID is primary key )

and a second  TABLE*(sellTable )  having the numbers books of the author which are sold

i mean the say that the all those authors whose books are being sold are entered in the second table

I have to display author's name and id from the forst list grouping the author  who  has sold the book once

Regards
Amin

*********************************************************
Disclaimer

This message (including any attachments) contains
confidential information intended for a specific
individual and purpose, and is protected by law.
If you are not the intended recipient, you should
delete this message and are hereby notified that
any disclosure, copying, or distribution of this
message, or the taking of any action based on it,
is strictly prohibited.

*********************************************************
Visit us at http://www.mahindrabt.com

pgsql-sql by date:

Previous
From: "David M. Richter"
Date:
Subject: View consistency
Next
From: 71062.1056@compuserve.com (--CELKO--)
Date:
Subject: Re: Recursive select