Your post is very confusing, you’ll need to elaborate.
In particular:
Badminton_Scoring:
I need to create several task to several people with the category
So your goal here is to create records in the Task Table? What else?
Badminton_Scoring:
I used select statement but it’s not creating several row ,it’s showing in single row
You used a SELECT expression, where? What was your SELECT expression? Screenshots are best. SELECT expressions by themselves do not “create” rows, so not sure what you’re saying there. And what do you mean by “it’s showing in single row”?
Employee table I am adding in another row in task table.
I am using select statement to one column where the category is same in Employee table.
My goal is to add multiple rows in task table
One category has different task name ,
Eg :
A catagory has 3 type of task…
If I click the action button in category table in any of the category item , automatically I need to add that 3 task has 3 individual row in task table