Search results

  1. E

    Some kind of join?

    Hi guys, Do you guys think this can be solved in one query? I have 1 table: | Name | Start Date | Value ---------------------------- | A | D1 | V1 | A | D2 | | A | D3 | | A | D5 | V3...
  2. E

    Add months for each person (query)

    Hello all, My dilemma is at it fallows Let's say we have 2 tables: Persons | Months ........A |Jan ........B |Feb ........C |Mar ...........|Apr ..................... ...........|Dec I am trying to get something like, in one selection: ....A | Jan ....A | Feb ....A...
  3. E

    Some kind of decizional descending sort...

    Hi, Here is my situation: I have a table with 3 fields: category, person and sum. What I need it's a group on category and after that an descending sort on sum (this way I have the maximum as the first value per each category). Well you'll probably say that it's a simple select, well not...
Back
Top Bottom