> Sorry, forgot to mention, the view needs to be editable. I thought
> that joins were only allowed for read-only views. Am I correct?

Then use triggers to make the view updateable again.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com