Database view

[DeveloperG]

Want to create a database view on incident table and sys_audit table to show those incidents where work notes have been added by a particular group member. 
Please help