select
`vtiger_account`.`accountid` AS `accountid`,
`vtiger_account`.`accountname` AS `accountname`,
`vtiger_account`.`parentid` AS `parentid`,
`vtiger_account`.`account_type` AS `account_type`,
`vtiger_account`.`empresa` AS `empresa`,
`vtiger_account`.`visualizacion` AS `visualizacion`,
`vtiger_account`.`epsconsolidada` AS `epsconsolidada`,
`vtiger_accountscf`.`cf_450` AS `NIT`,
`vtiger_accountscf`.`cf_2801` AS `AbrevEntidad`,
`vtiger_empresas`.`razonsocial` AS `razonsocial`,
`vtiger_accountscf`.`cf_2874` AS `Codigo_EPS`,
`vtiger_accountgrouprelation`.`groupname` AS `Regional`
from
(
join
on((`vtiger_account`.`accountid` = `vtiger_accountscf`.`accountid`)))
join
on((`vtiger_account`.`empresa` = `vtiger_empresas`.`empresasid`)))
left join
on((`vtiger_account`.`accountid` = `vtiger_accountgrouprelation`.`accountid`))
)
|