Correct syntax for getting information from two tables
I know this is possible and I've done it quite often in the past. But I haven't used MySQL in months(been doing some C++ work. Not that it has anything to do with C++.) Anyhow, what I have is two table Posts and Comments and I'm trying to get all the posts and then count the number of comments those posts have. I do not need to get any information from the comments table other than counting how many comments there are to a single post. I want to do this with mysql only.
Notice: If you post a problem and it gets fixed, please remember to go back and place it as solved. ;)
I always recommend the HEAD First series of books for learning a new coding language. ^_^