OK so now I have something like this: 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_privmsgs_block left join penpals_fav on penpals_privmsgs_block.user_id WHERE penpals_fav.fav_user_name = useronline.uname AND penpals_fav.user_id = $colname AND penpals_privmsgs_block.blocked_id IS NULL only this brings back nothing as when I remove the AND penpals_privmsgs_block.blocked_id IS NULL statement it results all the people online, but the "penpals_privmsgs_block.blocked_id" always equals 1 (the value I'm looking for on the blocked user only)for every record and none are null, which is in fact not the case. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
