I have the CASPIO table that has the same structure as my old MySQL DB.
I need to convert this mysql query into CASPIO REST api
$mquery = "SELECT m.*, DATE_FORMAT(m.created, '%e %b %Y %h:%i %p') AS message_date, u.fname, u.lname FROM cashbackengine_messages m, cashbackengine_users u WHERE u.user_id='$userid' AND m.is_admin='0' AND m.user_id=u.user_id ORDER BY created DESC";
I'm not sure whether CASPIO REST api supports join. If yes, how?
Can anybody help me?
Thank you.