-
gowrisankarAsked 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 SupportReplied 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
If you need further assistance, do let us know.
Regards