I'm trying to get the following query both functional and controlled via inner joins rather than this format, as the way it is now will be slow once the db fills up
I've never been good with joins and this is the first time for me working with MS SQL rather than MySQL
help?
SELECT top 5
[user_friend].user_friendID as friendID,
[images].name as friendImage,
[user_bulletins].id as bulletin_id
[user_bulletins].title as bulletin_title
FROM
[user_bulletins], [user_friend], [images]
WHERE
[user_friend].user_id = [user_bulletins].user_id
AND
[images].user_id = [user_friend].user_friendID
AND
([user_friend].user_id = 64)
OR
([user_friend].user_friendID = 64)
AND
[images].display_photo = 1