Hello Helen,

> Don't you need left joins to the lookup tables? Your query returns
> results only where ALL of the inner joins have matches, otherwise nothing.

yes, certainly... Thanks a lot :)

and one more question - what is better way:

to use left join view
or
use stored procedure, where get need data from tables ?

--
Best regards,
Maxim mailto:maxim@...