Join 2 tables

yes u can Do !

For your reference-:

$sqlobj ="select cs_c.number_c, cs_c.entity_c, cn.first_name,cn.id AS ContactID,cs.account_id,cs.assigned_user_id,cs.priority,cs.description,csrel.contacts_cases_1contacts_ida from cases cs
Inner join contacts_cases_1_c csrel ON cs.id=csrel.contacts_cases_1cases_idb
Inner Join contacts cn On cn.id=csre.contacts_cases_1contacts_ida
Inner Join cases_cstm cs_c On cs_c.id_c=cs.id
where csrel.contacts_cases_1cases_idb='".$id."' AND cs.deleted=0 AND cn.deleted=0";

$result = $GLOBALS['db']->query($sqlobj);
$row = $GLOBALS['db']->fetchByAssoc($result);

Print_r($row);

Thanks.

yes u can Do !

For your reference-:

$sqlobj ="select cs_c.number_c, cs_c.entity_c, cn.first_name,cn.id AS ContactID,cs.account_id,cs.assigned_user_id,cs.priority,cs.description,csrel.contacts_cases_1contacts_ida from cases cs
Inner join contacts_cases_1_c csrel ON cs.id=csrel.contacts_cases_1cases_idb
Inner Join contacts cn On cn.id=csre.contacts_cases_1contacts_ida
Inner Join cases_cstm cs_c On cs_c.id_c=cs.id
where csrel.contacts_cases_1cases_idb='".$id."' AND cs.deleted=0 AND cn.deleted=0";

$result = $GLOBALS['db']->query($sqlobj);
$row = $GLOBALS['db']->fetchByAssoc($result);

Print_r($row);

Thanks.

M kumar i am using curl request for that 

$instance_url = getInstanceURL();
$filter_url = $instance_url . "/RELIC_Reseller_Quotes/filter";
$filter_arguments = array(

    "max_num" => $rowsPerPage,
    "offset" => $row,
    "fields" => "id,name,quote_name_c,date_entered,reseller_id_c,secret_key_c,expiration_date_c,reseller_id_c,quote_number_c"
);
$filter_request = curl_init($filter_url);
curl_setopt($filter_request, CURLOPT_HTTP_VERSION, CURL_HTTP_VERSION_1_0);
curl_setopt($filter_request, CURLOPT_HEADER, false);
curl_setopt($filter_request, CURLOPT_SSL_VERIFYPEER, 0);
curl_setopt($filter_request, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($filter_request, CURLOPT_FOLLOWLOCATION, 0);
curl_setopt($filter_request, CURLOPT_HTTPHEADER, array(
    "Content-Type: application/json",
    "oauth-token: {$oauth_token}"
));

but i want reseller name and info which is saved in another module on the basis of reseller_id_c which is coming from above query

how can i do that?