$a = DB::connection('sqlsrv')
->table('ClasseContratoFinanceiro')
->select('ClasseContratoFinanceiro.Codigo')
->from(DB::raw('dbo.DocFinanceiro WITH (NOLOCK)'))
->join(DB::raw('dbo.ContratoFinanceiro WITH (NOLOCK)'), 'ContratoFinanceiro.AutoId', '=', 'DocFinanceiro.ContratoFinanceiro')
->join(DB::raw('dbo.ClasseContratoFinanceiro WITH (NOLOCK)'), 'ClasseContratoFinanceiro.AutoId', '=', 'ContratoFinanceiro.Classe')
->where('DocFinanceiro.Numero', $numero)->paginate(10);
Sign in to participate in this thread!
The Laravel portal for problem solving, knowledge sharing and community building.
The community