require a query to get the output

  • gowrisankar
    Asked on December 7, 2016 at 2:04 AM

     describe user;

    +---------+-------------+------+-----+---------+-------+

    | Field   | Type        | Null | Key | Default | Extra |

    +---------+-------------+------+-----+---------+-------+

    | id      | int(1)      | NO   | PRI | 0       |       |

    | name    | varchar(20) | YES  |     | NULL    |       |

    | address | varchar(20) | YES  |     | NULL    |       |

    | class   | int(2)      | YES  |     | NULL    |       |

    | DOB     | date        | YES  |     | NULL    |       |

    | created | date        | YES  |     | NULL    |       |

    +---------+-------------+------+-----+---------+-------+

    describe marklist;

    +------------+-------------+------+-----+---------+-------+

    | Field      | Type        | Null | Key | Default | Extra |

    +------------+-------------+------+-----+---------+-------+

    | id         | int(1)      | NO   |     | 0       |       |

    | subject    | varchar(10) | YES  |     | NULL    |       |

    | markscored | int(2)      | YES  |     | NULL    |       |

    | outof    | int(2)      | YES  |     | NULL    |       |

    | userid     | int(2)      | YES  | MUL | NULL    |       |

    +------------+-------------+------+-----+---------+-------+

    these are the two tables given and from these two i require an out put to be as :

    +---------+-------+-------+--------+-------+-----------+-----------+

    |name  |class |biology| chemistry|physics| outoftotal | totalmarkscored  |percentage|

    +--------+-------+-------+---------+-------+--------+---------------+

    |arun    | 5  |  45  |  42  |  40 |  150  | 127  |84.6|

     kindly give me a query to get the above output using the two tables user and marklist

  • Chriistian Jotform Support
    Replied on December 7, 2016 at 3:58 AM

    Hi gowrinsankar,

     

    If you want to create forms with the above requirements, it is achievable in JotForm. All you need is to start building your forms by dragging and dropping fields from the form builder.

    Here are some helpful guide on how to create forms:

    How to create your first web form

    How to position fields in JotForm

    How to Manage Multiple Fields

     

    If you need further assistance, do let us know.
    Regards