Join On Selectdataraw In Rest Api

[EijiKimura]

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.

 

Eiji

[GoCubbies]

Here is the list of the current operations supported by Caspio REST API: http://howto.caspio.com/integration/web-services-api/rest-api/operations/

[NailDyanC]

Hi, Just to update this post. You may check this updated link  of the list of the current operations supported by Caspio REST API: https://howto.caspio.com/web-services-api/rest-api/