Delete with join and condition (3 tables) - MySQL
Able to find the answer in another post... Sorry for raising this as duplicate

DELETE `stn` FROM `snote` AS `stn` 
LEFT JOIN `bnote` AS `ban` ON `ban`.`bnote_id`=`stn`.`bnote_id` 
WHERE `ban`.`note_id`='5' AND `stn`.`bnote_id` = '10'