ssage ---
From: gerald_clark <[EMAIL PROTECTED]>
To: vernon <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED]
Sent: Mon, 23 Jun 2003 11:13:53 -0500
Subject: Re: SQL query - 3 tables - 3rd one conatins records to not display
> And what happens if you leave off the 'distinct'
And what happens if you leave off the 'distinct' ?
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
pen
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_fa
; To: [EMAIL PROTECTED]
> Subject: RE: SQL query - 3 tables - 3rd one conatins records
> to not display
>
>
> 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, penp
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.f
What you need is a LEFT JOIN. When you use a LEFT JOIN, you get all rows
from your main table, with either the data from the
penpals_privmsgs_block table if there is corresponding data, or NULL if
there is no related row. Take a look here:
http://www.mysql.com/doc/en/JOIN.html for more information.
