1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Default count(*) to 0

Discussion in 'Databases' started by sc_king, Dec 27, 2009.

0
  1. #1
    When left joining a count(*) to a each id, is there a way to default the count(*) to 0 instead of NULL if there are none?
     
    sc_king, Dec 27, 2009 IP
  2. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #2
    Can you post the query you are trying to run?
     
    jestep, Dec 28, 2009 IP
  3. sc_king

    sc_king Peon

    Messages:
    29
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Hi,

    select * from companies LEFT JOIN (select company_id, count(*) from parts group by company_id) as parts_per_company ON companies.id = parts_per_company.company_id

    if a company does not have any parts, I want it to display 0 instead of null on the left join.
     
    sc_king, Dec 28, 2009 IP
  4. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #4
    Use
    COUNT()
    Code (markup):
    instead of
    COUNT(*)
    Code (markup):
     
    digitalpoint, Dec 28, 2009 IP