Trying to get results from 5 tables where the userId is the same. I am getting like 8k rows for where there should be about 20-30 or so. Here is my statement:
mysql_query("SELECT * FROM userrating, postratings, blogCommentRatings, commentratings, gamecommentratings WHERE userrating.userId = '$this->userId' AND postratings.userId = '$this->userId' AND blogCommentRatings.userId = '$this->userId' AND commentratings.userId = '$this->userId' AND gamecommentratings.userId = '$this->userId'") or die(mysql_error());
I am getting results like a cross join where every combination of rows possible is coming back. I know there is some sort of JOIN that may help me can anyone give me some advice?