cidr (12/11/2012)

---

Hi there,

Apologies for the elusive subject title. I'm trying to filter only rows on one field only when another field has a certain value.

I have a query with several columns. One column (called NAME) has only two values so to keep this simple for the question the values are

Paul
Jim

This column will only ever have these two values for all the rows.

I have another column (called POSITION) that only ever has three values

Staff
Manager
Executive

I want to filter rows on another column that only applies to Paul.

For example

Where NAME is = to PAUL only include rows from POSITION where they are MANAGER.

If the NAME is Jim, the filter will not apply to POSITION.

I'm unsure how to achieve this filter without affecting rows where the NAME is Jim.

I hope this makes sense.

What would be the easiest way to do this on the WHERE clause?

Many thanks

WHERE (NAME = 'Paul' and POSITION = 'MANAGER')  or NAME = 'Jim'

nigelrivett (12/11/2012)

---

where (name = 'Paul' and position = 'manager')
or name = 'Jim'