Tricky query.

[cjard]

There is always a better way to do the things

Yup.. structuring your DOCDATA table completely differntly would be one such a thing! That design of docdata is a very poor way of splitting an M:N relationship