> the inner join would certainly give me the results I need but, unfortunatenly, the query, application and GUI for the end users are all highly integrated and it's not that easy for me to have a specific inner join query instead of the program's standard query.

In this case you can create a view with inner join inside and tell
application to query this view.

SY, SD.