Hey guys im new to the forum loocated it when looking for help with this query, i know the basics of SQl but want to further my knowledge.Here is the situation I have 4 tables MEMBERS, WAR, VCLSCORES and OTHERSCORESIm basically just mucking around creating a stats table that displays scores in flags for all clan wars played by my clan. the WAR table consists of WarIdMapModeTime ClanPlayedVCLSCORES table consists ofWarIdIdNo (used to retrieve member details from member table)KillsDeathsFlagsOTHERSCORES consists of WarIdNameKillsDeathsFlagsI am trying to create a query that will grab all the details from WAR and a SUM of the flags columns from each VCLSCORES and OTHERSCORES for every war. I can get the query to work for WAR and VCLSCORES but as soon as i try to get the SUM for OTHERSCORES aswell i get a whole heaps of crap numbers.This is the query i am using to get the two tables workingSELECT WAR.WarId, WAR.Map, WAR.Mode, WAR.Time, WAR.ClanPlayed, SUM(VCLSCORES.Flags)FROM VCLSCORES INNER JOIN WAR ON VCLSCORES.WarId = WAR.WarIdWHERE VCLSCORES.WarId = WAR.WarIdGROUP BY WAR.WarId Any ideas how to add a SUM for OTHERSCORES into this query????Please help.Thanks guys