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]
