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
Bookmarks