Questions tagged as 'querybuilder'

I'm having the following problem, when trying to implement a query with joins, in the query builder: My Query (pure SQL): SELECT COUNT(*) as total, orgao.sigla AS sigla_org_uni FROM protocolo INNER JOIN procedimento p ON protocolo.id_pro...

I'm developing an application in Laravel 5 where I have the tables employees , companies , exams , employee_exams and their respective fields as migration below: :: Table Companies public function up() { Schem...

I have the following problem, I have a select using leftJoin , plus this is returning duplicate records, the database is not duplicated and when I run leftJoin it works. Follow SQL Tabela processo -----------------------...

I'm having a problem while accessing a column in the laravel query builder, the following code works in the Sql Workbench. Vendas::selectRaw('if(faturamento.Codfaturamento is null, vendas.totalvenda, faturamento.valor) AS vlrFatura') -...