Thanks for your answer.
While doing this, I have the placestay of the first numstay found, and not the one corresponding to the max numstay.
A not perfect solution would be to add a field max_numstay in the person table, but it's not really good...
Have you another idea?
Hi!
First, excuse me, my english is not good at all.
So I try to explain :
I have 2 tables : "person" and "stay".
For one person, we can have one or more stay.
I want to select all the person and their last stay and I don't know how to do it.
I tried like that ...
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.