good ideas! I will do something along these lines.

thanks all!
kelly

--- In firebird-support@yahoogroups.com, Dimitry Sibiryakov <sd@...> wrote:
>
> > 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.
>