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...
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
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.