Do OR and AND instructions form Facebook FQL instructions?

Question

I am trying to execute a translucent query using Facebook FQL.

SELECT message FROM stream WHERE actor_id= userid_1 AND source_id=userid_2 OR actor_id=userid_2 AND source_id=userid_1

Every time I run it, it becomes empty, although there are messages between the two users on the walls, so is this possible or do I need to use some alternative method?

Answer 1

It should work with a combination. Why aren't you trying to include the appropriate brackets, for example

SELECT message FROM stream WHERE actor_id = userid_1 AND (source_id = userid_2 OR actor_id = userid_2) AND source_id = userid_1