Want to show 3 tables in the same gridview and want to update/delete in parallel [closed]

Question

Suppose I have 3 tables. But I want to show them it in same gridview and want to update and delete operations in parallel. How can I do that?

table 1: workshop

id   contents   demonstration   coursefee  proviedMaterial
1    oneday        NULL           400        NULL
2    twoday        NULL           1200       NULL

table 2: demonstration

id   DayWorkshop   demonstration  
1    oneday        SQLInjection                 
2    oneday        XSS Demo
3    oneday        HTTrack          
4    twoday        Tools demo
5    twoday        Firewall
6    twoday        Cryptography

table 3: providedMaterial

id  DayWorkshop providedMaterial
1    oneday    Participation Certificate.
2    oneday    List of Our Latest short or long term courses .
3    twoday    Participation Certificate.
4    twoday    List of Our Latest short or long term courses Conducted.

Reason I took 3 table because I want to update all contents. Also, can I combine these 3 table into a single table so that I can easily show it in a gridview?

Answer 1

You can create a view to show the information from all tables and use it in your next queries

CREATE VIEW ResultTable AS
SELECT * 
FROM workshop ws
INNER JOIN demonstration dem ON ws.contents=dem.DayWorkshop
INNER JOIN providedMaterial pm on ws.contents=pm.DayWorkshop

This will allow you to see the combined data. You can use this view to make your update and delete queries (not the view