MySQL sql statement question

[Jassim Rahma]

I have the following statment:

SELECT * FROM member_channels WHERE member_channel_address = param_member_channel_address;

that's member_channels where I also have member_channel_id (primary key) In member_posts, I have member_channel_id.. I want to count total posts linked to member_channel_id and I want to display it as count field in the above statement..

[jschell]

Something like the following SELECT *, count(p.member_channel_id) FROM member_channels c, member_posts p WHERE c.member_channel_address = param_member_channel_address and c.id = p.member_channel_id

[Jassim Rahma]

thanks but there is one problem. when member_post has no rows linked to the same member_channel_id, it will not return anything but I want it to return the details with zero count

[Lost User]

jrahma wrote:

but there is one problem.

We call it a JOIN. Try Visual Representation of SQL Joins[^] :)

Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]