Return a result

[The Little Guy]

How can I get this code to work?

SELECT * FROM users LEFT JOIN pref ON (users.id = pref.owner),friends WHERE 
pref.owner = '45'
AND
(requester = '45' OR receiver = '45')
AND
(requester = '1' OR receiver = '1')

 

It MUST return a result if there is a user, even if the user doesn't have any corresponding pref owner.

 

If their isn't any user, then it shouldn't return a result. The maximum number of results this can and will return is one.

 

So, how can I get a result? The above code should return one result.

[corbin]

Not sure exactly what your table schema is, but you could try changing

pref.owner = '45'

 

to

 

users.id = '45'

[Mchl]

Apart from pref.owner thing - Isn't what you mean actually:

(receiver = 1 AND requester = 45)
OR
(receiver = 45 AND requester = 1)

?

[The Little Guy]

Apart from pref.owner thing - Isn't what you mean actually:

(receiver = 1 AND requester = 45)
OR
(receiver = 45 AND requester = 1)

?

 

IDK, what I have for that part works for me..

[Mchl]

I don't know any more than you It's just that it looks logical to me at a glance.

[corbin]

You could probably just do:

 

 

SELECT * FROM users LEFT JOIN pref ON (pref.owner = 45),friends WHERE

users.id = 45

AND

(requester = 45 OR receiver = 45)

AND

(requester = 1 OR receiver = 1)