SQL Query

[Sketch]

Hi, I have a problem with my SQL Query

SELECT A_ID, A_TITLE, COUNT( B_ID ) 
FROM ComBoard, msBoard
WHERE A_ID = B_ID
GROUP BY A_ID

Its very simple. Its counting how many B_ID's = A_ID. But my problem is, if the count = 0 it will not show up.

For example;
I have;
A_ID = 1
A_ID = 2
A_ID = 3

And

B_ID = 2
B_ID = 3

My query will return

A_ID: 2 & 3

But not A_ID 1.

I hope that makes sence.

If some one could give me a hand that would be great.

Thank You

[littleFella]

SELECT A_ID, A_TITLE, COUNT( B_ID ) 
FROM ComBoard, msBoard
WHERE A_ID = B_ID
GROUP BY A_ID

You used INNER JOIN which will return only thiose record for which there are matches in both tables.

You should use LEFT or RIGHT JOIN, depending which table lacks the matching records.

PHP Code:

SELECT A_ID, A_TITLE, COUNT( B_ID ) 
FROM ComBoard, msBoard
[b]LEFT[/b] JOIN second_table
ON ComBoard.A_ID = ComBoard.B_ID
GROUP BY ComBoard.A_ID

or

SELECT A_ID, A_TITLE, COUNT( B_ID ) 
FROM ComBoard, msBoard
[b]RIGHT[/b] JOIN second_table
ON ComBoard.A_ID = ComBoard.B_ID
GROUP BY ComBoard.A_ID 


[Sketch]

Gosh, I feel so stupid that I didn't even think of that.

Thank You so much I was stuck on it and I had no idea what to do.

I had to change the code a little, but it works great now.


Cheers Again!