AnsweredAssumed Answered

How to Avoiding subqueries with our Web Services API

Question asked by Ramana Raju on May 29, 2015
Latest reply on Jun 2, 2015 by Rolustech Rolustech
Hi All,

How to Avoiding subqueries with our Web Services API..

I want this query to be execute and get the out put by using any API

SELECT project.id, project.desc, accounts.id, accounts.fullname, accounts_cstm.region_c
FROM projects_accounts
INNER JOIN accounts
ON accounts.id = project_accounts.account_id
INNER JOIN project
ON project.id = porject_accounts.project_id
INNER JOIN accounts_cstm
ON accounts_cstm.id_c = accounts.id
WHERE projects_accounts.deleted = 0
AND accounts.id = 'c0a26d67-ca8e-e5a3-25f9-5541fb084de6'
AND accounts_cstm.region_c REGEXP 'USA'

When i execute this query from phpmyadmin am getting all my records but how to write and retrieve from the API and where is the file path

Can anyone plz suggest how to implement..

Thanks,
Ramana

Outcomes