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