Problem with query

[Sim]

SELECT
    COUNT(JR_refID) AS rankCount,
    J_id AS id,
    J_name AS name,
    J_desc AS `desc`
  FROM
    jobs
  JOIN jobRanks ON(J_id =JR_refID)
  GROUP BY J_id
  ORDER BY J_id ASC

 

My problem is if theres a job with no Ranks, it is not included in in the results. What am I missing? Thanks in advance!!

I know @Magictallguy got an answer here.

[AdamHull]

You need to use LEFT JOIN then this should solve your issue 

SELECT
        COUNT(JR_refID) AS rankCount,
        J_id AS id,
        J_name AS name,
        J_desc AS `desc`   
    FROM
        jobs   
    LEFT JOIN
        jobRanks 
            ON(
                J_id =JR_refID
            )   
    GROUP BY
        J_id   
    ORDER BY
        J_id ASC

Edited January 24, 2021 by AdamHull