At 09:02 16.07.01 -0700, John Hawkins wrote:
>I'm having a bit of trouble doing a LEFT JOIN. Any input would be greatly
>appreciated.
>
>table 1 (sites, has approx 30 records) has a list of sites with the
>following fields:
>ID, sitename, url
>
>table 2 has (ratings, has approx 2020 records) has
SELECT ratings.memid, sites.*
FROM ratings LEFT JOIN sites
ON ratings.ID = sites.ID
WHERE ratings.memID = '1' and sites.ID IS NULL;
John Hawkins wrote:
> I'm having a bit of trouble doing a LEFT JOIN. Any input would be
> greatly appreciated.
>
> table 1 (sites, has approx 30 records) has a li
