Project: QGIS
Version: 3.2.0
The 'Join by attribute table' algorithm has been upgraded to support one-to-many joins (i.e. create separate features for each matching feature) as well as an option to discard records which could not be joined. Additionally, an optional prefix for joined fields can now be specified.
This feature was developed by Mathieu Pellerin, Nyall Dawson