General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Selecting records where agration of 2 fields is not equal
I figured out how to use a left outer join to get values in table 1 and any matching records in table 2. there are 4 fields.
I know how to sum fields 3 and 4 by field 1 (ie select 1 sum(3) as s1 sum(4) as s2 form a order by 1 group by 1 into b).
What I do not see how to do in this step is how to select only records where sum(3) <> sum(4) in the above select.
I can do it in a subsequent select.
Can it be done?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only