OSM-SQL

List goals for the primary alternative.

List suggested alternatives that satisfy all needs.

select Goal

from satisfies, Goal, Primary Alternative

where Suggested Alternative = Primary Alternative and Goal = Need

select Suggested Alternative

from Suggested Alternative A

where not exists (select *

from Need N

where not exists (select *

from satisfies S

where N.Need = S.Need and

A.Suggested Alternative = S.Suggested Alternative))

Previous slide

Next slide

Back to first slide

View graphic version