Can you list the asset ids, the fault log entry ids and the fault descriptions?
select asset_id, fault_log_entry_id, fault_description from fault_log
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 )
Please just list the asset model of those assets.
select asset_model from assets where asset_id not in ( select asset_id from fault_log )