Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
-
Problem with using NOT IN
You are damn right. 4.0.22 is what I am having. Any idea to do what I am looking for with this release? -
Problem with using NOT IN
I didn't include the double quote at first, and this is what I got: ERROR 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 loanID from commitmentAssign WHERE commitmentID =8)' at -
Problem with using NOT IN
table 'loan': +--------+ | loanID | +--------+ | 1 | | 2 | | 5 | | 10 | | 15 | +--------+ table 'commitmentAssigned': +--------------+--------+ | commitmentID | loanID | +--------------+--------+ | 8 | 1 | | 9 | 1 | | 9 | 10...
