Hello I have a little problem. I need to joing 2 by 2 columns from different tables. But it does not work:
->leftJoin('q_prelivnik', 'nivo_prelivnik.date1+nivo_prelivnik.time1', '=', 'q_prelivnik.date1+q_prelivnik.time1')
the full code of query:
$students = BelmekenKota::whereBetween('nivo_prelivnik.date1', $dateScope)
->selectRaw('(nivo_prelivnik.date1+nivo_prelivnik.time1) as timestamp,izch_nivo,q_prelivnik.debit, q_prelivnik.date1, q_prelivnik.time1,nivo_prelivnik.id,q_prelivnik.id')
->leftJoin('q_prelivnik', 'nivo_prelivnik.date1+nivo_prelivnik.time1', '=', 'q_prelivnik.date1+q_prelivnik.time1')
->orderBy('timestamp', 'ASC')
->get();
I tryed with:
->leftJoin('q_prelivnik', 'nivo_prelivnik.date1+nivo_prelivnik.time1 as timestamp', '=', 'q_prelivnik.date1+q_prelivnik.time1 as timestamp2')
and
->leftJoin('q_prelivnik', 'timestamp', '=', 'timestamp2')
Failed again.
Any idea ho to do it?