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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Subquery problem
Big thanks for getting me to double check the version. I did have version 5.0 installed on my PC, but I was connecting to 4.0. Anyway, got it working now Thanks. -
Subquery problem
Hi Sorry about that. The Error I get is this: _____________________________________ SQL-query: SELECT * FROM sm_articles WHERE articles_pk < ( SELECT MAX( articles_pk ) FROM sm_articles ) MySQL said: #1064 - You have an error in your SQL syntax near 'SELECT MAX(articles_pk) FROM... -
Subquery problem
Hi I trying to use a simple subquery to find out the highest primary key in a table and print all of the results other than that one, but I keep getting a syntax error related to the subquery and I have no Idea why... Does anybody know what I'm doing wrong? Here is the code: SELECT *...
