i have two tables clients and related payments, one table is clients with fields “id_client”, “name”, “phone” and another table with fields “id_payment”, “id_client”, “PaymentDate”, “PaymentStatus” i want each first of Each month new rows are generated in the payments table, but each row must contain its respective client_id from the clients table. as I would do it ?
