SQL Join Query to Update the Client Table but the Inserted Values should also be inserted into Project Table and Payment Table in C# Add Button

Database Name: WFM_CMS

Table Names: Project, Payment, Client

Project Table Column Name Data Type ProjectID int ProjectName varchar(50) ProjectDescription varchar (50) StartDate date EndDate date ProjectStatus varchar (50) Payment Table Column Name Data Type int float varchar (50) PaymentID PaymentAmount PaymentType PaymentDate TotalPaidAmount DuePaymentAmount date float float Grand Total float Client Table Column Name Data Type ClientID int ClientName Email varchar (50) varchar (50) varchar (50) varchar (250) ContactNo Address int varchar (50) varchar (50) int varchar (50) date ProjectID ProjectName ProjectDescription ProjectCost ProjectStatus StartDate EndDate Payment Amount Payment Type PaymentDate TotalPaid Amount DuePayment Amount Grand Total date float varchar (50) date float float float