vernon wrote:
OK so now I have:
SELECT distinct useronline.uname, penpals_fav.fav_user_id, penpals_fav.ID, penpals_privmsgs_block.user_id, penpals_privmsgs_block.blocked_id
FROM useronline, penpals_fav LEFT JOIN penpals_privmsgs_block ON penpals_fav.user_id = penpals_privmsgs_block.user_id
WHERE penpals_fav.fav_user_name = useronline.uname AND penpals_fav.user_id = colname
which comes back with a "1" in every record again and of course when I add the AND "penpals_privmsgs_block.blocked_id IS NULL" it comes up empty as every row has a 1 in it.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]