Re: How to count rows in a sub-table

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Vishal Parkar (REMOVE_THIS_vgparkar_at_yahoo.co.in)
Date: 05/18/04

Next message: Sreedhar Kaluva: "setupsql.exe hangs. Cannot Install SQL server 2K"
Previous message: Q: "Re: Grant Execute right to the group of users"
In reply to: Leo Violette: "How to count rows in a sub-table"
Next in thread: Leo Violette: "Re: How to count rows in a sub-table"
Reply: Leo Violette: "Re: How to count rows in a sub-table"
Messages sorted by: [ date ] [ thread ]

Date: Tue, 18 May 2004 06:47:11 +0530

use left outer join

Ex:

  select books.BookName, Count(orders.bookid) as TotalSold
  from Books left outer Join Orders on Orders.BookID = Books.BookID
  group by books.BookName
  order by books.BookName

  --
  Vishal Parkar
  vgparkar@yahoo.co.in | vgparkar@hotmail.com

Next message: Sreedhar Kaluva: "setupsql.exe hangs. Cannot Install SQL server 2K"
Previous message: Q: "Re: Grant Execute right to the group of users"
In reply to: Leo Violette: "How to count rows in a sub-table"
Next in thread: Leo Violette: "Re: How to count rows in a sub-table"
Reply: Leo Violette: "Re: How to count rows in a sub-table"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Re: Combine results based on a value
... I have BOOK_RENTALS which contains customer names and books: ... JOHN SMITH, BOOKA ... You might try doing this with an outer join, ... Left outer join syntax: ...
(comp.databases.oracle.server)
Re: Better way to sum 0 entries?
... I originally thought of this Tom, but the outer join should also include the ... > where b.LibraryID = l.LibraryID) as Books ... > LibraryID INTEGER, ...
(microsoft.public.sqlserver.programming)
Re: How to count rows in a sub-table
... That did the trick. ... I had tried left outer join previously, ... was forcing all rows to be at least one. ... from orders instead of books did the trick. ...
(microsoft.public.sqlserver.programming)