Search the Community
Showing results for tags 'join'.
Found 2 results
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
I have joined 3 tables in a view and the default join type is "Include only matching records". I would like to "Include all records", but this is grayed out and I am not allow to select it. What could be preventing me from selecting it? Thanks, Scott