I'm so frustrated with these table joins.... I'm pulling info almost directly from the mysql ref. man. OK. I've got two tables: passwords and partners. I want to pull every password that doesn't have a corresponding partner.
Password table:
site <-- can match up with name in partner table
partner table:
name
I've got a query that works to pull every site that DOES HAVE a matching partner name, but now I need to pull the remaining ones.
From searching, I know there's no (+) operator like in ORACLE, but what do I have to do??
SELECT DISTINCT site FROM passwords
WHERE EXISTS
(SELECT * FROM partners WHERE partners.name = passwords.site)
This gives me an error.
I can't even get this working:
SELECT site FROM passwords WHERE EXISTS (SELECT * FROM partners)
and that's just an example EXISTS query from the mysql docs... what am i missing?!?!
