I'm famililar with other DB systems, but for some reason am having a
problem with the simplest of queries.....
SELECT *
FROM table1
WHERE famc NOT
IN (
SELECT familyID
FROM table2
)
Why isn't this working?? I'm on version 4.0.25 something....I get
#1064 - You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near........... ...
According to mysql docs it's supposed to work....
problem with the simplest of queries.....
SELECT *
FROM table1
WHERE famc NOT
IN (
SELECT familyID
FROM table2
)
Why isn't this working?? I'm on version 4.0.25 something....I get
#1064 - You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near........... ...
According to mysql docs it's supposed to work....
Comment