I am trying to figure out why a certain style of SQL statements are not working in MySQL. I'm not sure if it is because I am using a 3.X (not sure of the exact version) release.
Here is the statement:
SELECT * FROM FL_State_List
WHERE AreaCode NOT IN (SELECT AreaCode FROM FL_AreaCode_List);
The table FL_State_List has a list of customers in Florida.
The table FL_AreaCode_List is a list of all area codes in Florida.
This statement works fine if I take out the Select statement in the where clause and replace it with actual area codes. If it makes any difference I am using MySQL-Front to run the code.
Thanks for any help,
Zych
Here is the statement:
SELECT * FROM FL_State_List
WHERE AreaCode NOT IN (SELECT AreaCode FROM FL_AreaCode_List);
The table FL_State_List has a list of customers in Florida.
The table FL_AreaCode_List is a list of all area codes in Florida.
This statement works fine if I take out the Select statement in the where clause and replace it with actual area codes. If it makes any difference I am using MySQL-Front to run the code.
Thanks for any help,
Zych