I have two tables with the design below:
I would like to construct a query / stored procedure that
would return a recordset with the companyid, metricname,
metricid, and financialvalue based on criteria supplied
by the user.
My query is returning records if one of the WHERE
criteria is met because of the OR operator. I need to
have all criteria met before returning the record.
WHERE (MetricID = 1) AND (FinancialValue > 0) OR
(Metrics.MetricID = 4) AND (FinancialValue > 0)
Will this construct need to be in the JOIN? ...