I've attached a pic of an excel spreadsheet with a table definition. I've been trying to write a SQL statement what will perform a SUM on TableF.Amount where TableG_ID <> 2.
However my sum gives me a result of 25 (adding the 10 + 15 together).
I tried to make the tables similar to what I am working with. Table G will have many rows of data and I need result to sum but exclude where TableG_ID = 2.