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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
JOIN query for subSELECT???
@shadedecho Thanks. You lost me on that one though - maybe I didn't explain it well enough. @swampBoogie You nailed it. Freak! That was too simple. I was staring right at it! DOH! I mean it was right there in front of me! I must have just blanked out or something! All I had to do was add... -
JOIN query for subSELECT???
Short Version of my problem: ====================== How do I do this query in MySQL 3.23.54?: SELECT blah blah FROM table1 WHERE table1.row_id NOT IN (SELECT table2.row_id FROM table2 WHERE column = myVariable); ====================== Longer Version!: I'm working on a form to modify course...
