select query: 'OR'

BEFOR

The following within the WHERE clause of a query brings back all rows that are identified by the 'OR' (from both tables)

WHERE Membs.MemID = McontD.Mem_ID and Membs.MemID = McontR.Mem_ID and (Membs.MemID= MrunR.Mem_ID) OR (Membs.MemID=MrunD.Mem_ID) AND '88' = Membs.MemID

In actuality, there may or may not be a values in either MrunR or MrunD

If I place 'AND' in place of 'OR' it returns only a single result which is what I want. Only problem is that if both MrunR and MrunD don't contain the Membs.MemID value, then no results are returned.

This needs to evaluate if either of the tables contains Membs.MemID

Is there such a thing as EITHER ...OR ...? How to do this?

halojoy

BEFOR wrote:
The following within the WHERE clause of a query brings back all rows that are identified by the 'OR' (from both tables)

WHERE Membs.MemID = McontD.Mem_ID and Membs.MemID = McontR.Mem_ID and (Membs.MemID= MrunR.Mem_ID) OR (Membs.MemID=MrunD.Mem_ID) AND '88' = Membs.MemID

In actuality, there may or may not be a values in either MrunR or MrunD

If I place 'AND' in place of 'OR' it returns only a single result which is what I want. Only problem is that if both MrunR and MrunD don't contain the Membs.MemID value, then no results are returned.

This needs to evaluate if either of the tables contains Membs.MemID

Is there such a thing as EITHER ...OR ...? How to do this?

either or

hmmmm
I will go see at
http://php.net

maybe - maybe not - isnt this also called XOR