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!

Register Log in
  • Congratulations Mike Lewis 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: *

  1. Mariellelis

    how works having max()?

    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?
  2. Mariellelis

    how works having max()?

    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 ...

Part and Inventory Search

Back
Top