| edlanter 2004-08-18, 3:56 pm |
| I have a decent amount of Oracle SQL experience so I don't know
what I have done wrong here. I have tried several different
iteration using aliasses, joins, IN vs NOT IN and nothing seems to
make this simple query work. Any feedback is much appreciated.
--------
SELECT _DISTINCT Player_Name, Pool
FROM Eligable_Players WHERE Player_Name NOT IN (
SELECT Player_Name
FROM Draft_1 _)
--------
Here is the error I get
--------
SQL-query : _
SELECT DISTINCT Player_Name, Pool
FROM Eligable_Players
WHERE Player_Name NOT
IN (
SELECT Player_Name
FROM Draft_1
)
LIMIT 0 , 30
MySQL said:
#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 'SELECT Player_Name
FROM Draft_1 ) LIMIT 0, 30' at line 5
--------
James Lanter
The Criminal
the_criminal@fantasycriminal.com
www.fantasycriminal.com
----------------------------------------
The post originated from PHP Freaks:
----------------------------------------
http://www.phpfreaks.com
http://www.phpfreaks.com/forums
|