Updating a column value from the value of the other table SQL – Phpmyadmin
I have a table chatmessages that has a chatId, incomingId, outgoingId column, and I have another table chatmembers which has a chatId, usersId column. Also another table chat that contains only the chatId, and the usersId initializer of the chat…