Hey,

I have this query:

Code MySQL:
SELECT friends.userid1, friends.userid2, customers.id, customers.profile_small_pic 
FROM friends 
WHERE friends.userid1 = 70 
INNER JOIN customers 
ON friends.userid2 = customers.id

if I remove the WHERE clause it works fine. Is there a way to define which userid1 I want? I don't want all of the data..

This is the error
Code:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INNER JOIN customers  ON friends . userid2 = customers . id
LIMIT 0, 30' at line 1