How do I join these two tables, showing results from the second table?
select A.cid, A.time, IF(A.cid = B.CID2,C.cpu,NULL) 
 from A 
 LEFT JOIN B on A.cid = B.CID2 
 where A.time ="2018-12-17 14:00:00";