AND / OR

[Anon]

I ran into a bit of a simple problem but im not figuring out why this it will not work.

The problem is with my query. What im trying to do is grab information from 2 tables. and saying if ifnormation equals this OR that OR that etc..

SELECT message., user. FROM message, user
WHERE message.userID = user.userID
AND (message.actionID='C')
OR (message.actionID='R')
OR (message.actionID='F')

Now what its doing is reapting the information. Any ideas why or what i did wrong?

[Anon]

I think you mean this:

SELECT message., user. FROM message, user
WHERE message.userID = user.userID
AND ((message.actionID='C')
OR (message.actionID='R')
OR (message.actionID='F'))

Notice the extra ()'s.

Greetz,

Vincent Driessen
Venlo, The Netherlands