Sample Query for System Notes of Vendor Records

To get System Notes of Vendor (eg. id 1111), kindly use the query below:

SELECT notes_system.name
        ,notes_system.comments
FROM vendors
JOIN notes_system ON (notes_system.company_id = vendors.vendor_id)
WHERE vendors.vendor_id = 1111
ORDER BY notes_system.time_entered DESC