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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: carlrichey
- Order by date
-
how works having max()?
Your English is fine. I don't know the exact structure of your tables, but something like this should work: select person.numperson, person.nom, stay.placestay, max(stay.numstay) from person, stay where person.numperson = stay.numperson group by person.numperson Note that this will...- carlrichey
- Post #2
- Forum: MySQL
-
sub select
Woops, I told u wrong. Must be late..... This is a little cleaner. SELECT users.name, users.user_id FROM users, portfolio LEFT JOIN portfolio p2 ON users.user_id = p2.user_id AND portfolio.course_id = p2.course_id WHERE portfolio.course_id = 13 AND p2.score IS NULL- carlrichey
- Post #7
- Forum: MySQL
-
sub select
dkpede didn't understand the problem... mickallen wants to bring back a list of all the users that have NOT taken course 13... although they may have taken other courses. dkpede's solution would have essentialy brought back all users because they all took course 1. The correct result set...- carlrichey
- Post #6
- Forum: MySQL
-
MySQL slow over LAN
I am running max-4.0.1-alpha-max-nt with MyODBC version 3.51.04 and am experiencing some odd performance problems. I have a long process that makes multiple sequential calls to the database and have noticed that when I run the application locally on the server, performance is quite good. If I...- carlrichey
- Thread
- Replies: 0
- Forum: MySQL
