Hmm, I want to know the asset ids that did not incur any fault log.
Select asset_id from Assets where asset_id not in  ( SELECT asset_id from Fault_Log ) 
asset ids that did not incur any fault log refers to assets without entries in Fault_Log;