1. Fabrik 3.9 has been released. If you have updated Joomla to 3.9, this is a required update.
    Dismiss Notice

Database join question...

Discussion in 'Community' started by frullix, Jul 28, 2020.

  1. frullix

    frullix New Member

    Level: Community
    I have this table:

    Result

    id-----Name----------Competition----------Result-----Competition nr
    1------Alex(id.2)----Lubjana Cup(id.4)------20-------------1 (id.1)
    2------Alex(id.2)----Lubjana Cup(id.4)------26-------------2 (id.2)

    Now I'd like to view in another list

    if Competition nr == 1 (or 2)

    return

    Name, Competition, Result_1, Result_2
    Alex----Lubjana Cup----20---------26

    how could I solve?
    Thank you in advance.
     
    Last edited: Jul 28, 2020
  2. juuser

    juuser Active Member

    Level: Community
    Hi, I think you need to explain a bit more your setup and what exactly do you want to achieve, e.g screenshots from table setups drawn in Excel etc.
     
  3. frullix

    frullix New Member

    Level: Community
    Yes sorry, it is really difficult to explain. I have made an outline with excel, I hope it is easier to understand[​IMG]
     
  4. juuser

    juuser Active Member

    Level: Community
    OK, seems clear now. It's a bit complicated.

    One option would be to make a players table and create calc elements for competition result 1, 2, 3 and 4. In the calc element you can query and sum the results.

    Or you could check out list "pivot" plugin (haven't used myself) or mysql views which you can link to Fabrik list.
     

Share This Page