John Wards wrote:
I have this query:
SELECT *
FROM news_category
LEFT JOIN news_x_cat ON news_category.id = news_x_cat.cat_id
WHERE (
news_x_cat.news_id = 9 OR news_x_cat.news_id IS NULL
)
Which gives me this output:
id title perm show news_id cat_id
1 About Us 1
You have not shown us anything that would indicate that your output is
not correct.
If you think something is missing you have to show us what is missing,
and why you think
it should not be.
John Wards wrote:
I have this query:
SELECT *
FROM news_category
LEFT JOIN news_x_cat ON
I have this query:
SELECT *
FROM news_category
LEFT JOIN news_x_cat ON news_category.id = news_x_cat.cat_id
WHERE (
news_x_cat.news_id = 9 OR news_x_cat.news_id IS NULL
)
Which gives me this output:
id title perm show news_id cat_id
1 About Us 1 1
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 a list
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 a list of member ratings
for the different sites
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 list