Hello guys,
I have been trying to select data from three tables, but am not good at joins The initial parameter is token. I have this tables
devices
user_id
token
users
first_name << this will be selected where from_id =user_id
last_name << this will be selected where from_id =user_id
user_id
messages
from_id
to_id << this is user_id from in devices & users
subject
read_dt
The final table will look like this
Result
first_name
last_name subject