Multiple table interaction

[lucianozanita]

Hello, I'm in a dilemma actually an impasse, I'm trying to assemble a query in the database with the new database interaction base WHMCS has developed, but I can not find an easy way to do a multiple query on two tables .

Using their example, I would also like to select three customfield fields from the currently listed account.

Since they are customfield1, customfield2, customfield3, but I have no idea how I can be using the query to do this, would anyone know how to do the same?

 

Here is an example used at this point that only lists the accounts, and needed to list the customfield value of the currently listed account.

 

 

foreach (Capsule::table('tblclients')->get() as $clientes) {

$primeironome = $clientes->firstname . PHP_EOL;

$segundonome = $clientes->lastname . PHP_EOL;

}