Thanks for your reply.
This is what I have come up with...but still not working. And not sure how to check if protocols have been setup for the monitoring type.
Gret if anyone has any more help or nudges in right direction
"SELECT asset_id, asset_date, asset_num, asset_serialNum, asset_name, asset_description, asset_type, asset_department, asset_owner
(asset INNER JOIN monitoring
ON asset.asset_id = monitoring.asset_id)
INNER JOIN protocols
ON monitoring.monitor_id = protocols.monitor_id