Sim Posted March 26, 2012 Share Posted March 26, 2012 My query is returning 0 for all COUNT's and NULL for rest any ideas. SELECT COUNT( cheat.cheatID )AS cheats, COUNT( review.reviewID )AS reviews, COUNT( image.screenID )AS images, COUNT( news.newsID )AS newz, COUNT( video.videoID )AS videos, game.gameID, game.gameName, game.gameFType FROM games AS game, game_cheats AS cheat, game_reviews AS review, game_screens AS image, game_news AS news, game_videos AS video WHERE cheat.cheatGameID = game.gameID AND review.reviewGameID = game.gameID AND image.screenGameID = game.gameID AND news.newsGameID = game.gameID AND video.videoGameID = game.gameID ORDERBY game.gameName DESC LIMIT 0 , 50 Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.