Join On Selectdataraw In Rest Api

[munkitkat]

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.

[aam82]

Did you try creating a View, and then querying the View?

 

Also, I'm curious if you're building a server app or a client app? What's your stack? Thanks