I have a MySQL database with tables ‘event’ and ‘user’. They are connected via foreign key ‘userID’. In my scheduler I would like to display the name of the user that “owns” the event, but name is stored in DB table ‘user’ so I don’t know how to get and attach that data to the event.
I tried simply adding the ‘name’ column from ‘user’ table in my render_sql command and I can read data from DB, but it obviously doesn’t work when I add a new event because it tries inserting column ‘name’ to table ‘event’. How should I solve this?
Thanks in advance, Alex