This is a sql statement i use to get data i desire
select kakitangan.nama, kakitangan.nokp, tbtemp1.id
from kakitangan
left join (select id,tarikh, kakitangan from harikerja where tarikh = '2016-05-15') as tbtemp1 on kakitangan.id = tbtemp1.kakitangan
where tbtemp1.id is null
I alredy has a working Kakitangan and Harikerja model generated using Gii.
I understand the basic to use active record for select, where, andWhere, but not to create subquery and use it in a join.
So how to convert the sql statement above to yii2 active record query?